Hi,
I am not sure if this is possible (or even if it is a good idea!) but is it possible to use the form name and control name to dynamically build the RowSource for a combo box?
I have a client who wants to be able to copy a combo box from a default template form to new forms in design view without having to set the RowSource individually for each combo. The idea is to have a Lookup_Variables table, which has 3 fields; FormName, ControlName and Item. This would contain all the list items for every combo box in the application.
I know it would be possible to add a Form_Open event procedure to every form which looped through all the combo boxes on the form and set the RowSource property at that point, but the client wants to be able to create a new form, copy in the default combo box multiple times, name each one and then add the ListItems to the Lookup_Variables table for each one without adding any new code.
Possibly a strange request? Any pointers would be appreciated!
Jim
I am not sure if this is possible (or even if it is a good idea!) but is it possible to use the form name and control name to dynamically build the RowSource for a combo box?
I have a client who wants to be able to copy a combo box from a default template form to new forms in design view without having to set the RowSource individually for each combo. The idea is to have a Lookup_Variables table, which has 3 fields; FormName, ControlName and Item. This would contain all the list items for every combo box in the application.
I know it would be possible to add a Form_Open event procedure to every form which looped through all the combo boxes on the form and set the RowSource property at that point, but the client wants to be able to create a new form, copy in the default combo box multiple times, name each one and then add the ListItems to the Lookup_Variables table for each one without adding any new code.
Possibly a strange request? Any pointers would be appreciated!
Jim