I have looked on the net and in my Access books and I can't find the code to dynamically add controls, such as combo boxes, labels, etc. to a form. I would like to have a drop down box so the user can pick a number and that many combo boxes and labels would be created. And once that is done can the source for the combo box be then set?

Thanks,
Scott

__________________
ScottP

That's one option. I usually just create the combo boxes and labels and make them invisible. Then on the combo box after update event, set the combo boxes visible. I think you can either set the recordsource beforehand, or on the fly, but I don't have experience with that.

Also, make sure you use whatever code you use on the combo box after update event on the form's on current event.

HTH?

mmcdonal

I read your Q about testing txtBSCPIN1 to txtBSCPIN16 at EE and commented at:
http://thecrappyexpertsexchangeblog.blogspot.com/
Issue 16 is showing how to solve this using no-code.

Regards,

Nic;o)