Forms based off of a crosstab query.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form based off of a crosstab query (dates down the left, employee
names across the top), and right now the form displays all the information
correctly. However, if I were to add a new employee, the new employee's
information would not show up in the form, because there isn't a designated
label for it.

What I want to do is have labels show up without having to edit the form
each time a new employee is added. Is there a way to dynamically add labels
during the forms load event? I know how to do this in VB.NET, but don't know
how you would do it in VBA.

What would be the easiest way to solve this problem?
 
Hi,


You can, but you have to place the form in design view (a little bit like
wizards do, anyhow, when adding controls). It is relatively "ugly" in a
production environment, so, may be you will prefer to pre-create them,
HIDDEN, and un-hide them, as required.




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top