Form generation at runtime

A

Alp

Hi Experts,

Is it possible to generate an entire form or the controls on a form via VBA
and maybe some query(ies) depending on the data in a table when it is
called? (I hope the question makes sense)

Thanks in advance.

Alp
 
B

Bas Cost Budde

Alp said:
Hi Experts,

Is it possible to generate an entire form or the controls on a form via VBA
and maybe some query(ies) depending on the data in a table when it is
called? (I hope the question makes sense)

The question makes sense to me; I have working on this for a time.

(a) you can only change the design of a form when it is in design view
(that is not when you open it)
(b) it is possible, and not too difficult, to create a form based on a
table; it depends on the amount of variation in the design, and the
available information to create the form.

The Case project on my site may provide more to your need. I am not sure
how much of the graphical system I put into it. You can contact me for
more information if you wish.


Why does the question arise, in your case?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top