SubForms

S

Shell

In Access 2000, How do I in code select which subform to display on a form
based on a combo box value?


Thanks
 
D

Douglas J. Steele

Assuming that the name of the subform control is subForm, and the combo box
(cboWhatSubform) returns the name of the form to be displayed as the
subform.

Me!subForm.SourceObject = Me.cboWhatSubform

Note that it's usually a good idea to reset the LinkMasterFields and
LinkChildFields properties when you change the SourceObject, even if they're
the same as for other subforms.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup in Continuous form 0
Link a text box based on drop down box with four options MS Word 365 0
Populate main form from subform record 0
Referring to control in the active subform 0
Which event? 5
Refreshing a subform 2
VBA code returns no records hwenKey ID is added 14
main form/subform 1

Top