Form generation at runtime

  • Thread starter Thread starter Alp
  • Start date Start date
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
 
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)
Click to expand...

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?
 
Back
Top