SubForms

  • Thread starter Thread starter Shell
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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

Cascading combos in datasheet 0
Refreshing a subform 2
Using combo box when adding records to continuous form 1
Which event? 5
Populate a field based on a visible value in a combo box? 2
Pass Subform filter to subform in report 0
Choosing subform to display based on combo box 1
How stop subform adding blank values? 3

Back
Top