Forms based off of a crosstab query.

[Monkey_O]

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?

 

[Michel Walsh]

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

 

[Duane Hookom]

You can simply set the Source Object of a subform control to you query name.
Check the dynamic subform sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane