Link a menu Tab to a subform (Combo Box)

  • Thread starter Thread starter Alimbilo
  • Start date Start date
A

Alimbilo

Hello,
How can I link a sub menu Tab (in a combo box) to open a subform?

Example:
In the Combo Box, I have - Age, - Gender, - Country

And I want the Age Form to open as a SUBFORM when I click on the -Age (in
the combo box).

Thank you
 
use one subform control and change its SourceObject property bsaed on the
selection.

Select Case cboFormList
Case "Age"
me.SubformControlName.SourceObject = "frmAge"
Case "Country"
me.SubformControlName.SourceObject = "frmCountry"
etc...

Of course, if one of the columns in your combo ncluded the form name you
could use that directly:

Me.SubformControlName.SourceObject = cboFormList.Column(2)
 

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

subforms: using input from one subform to update the other subform 2
Cascading combos in datasheet 0
Access Control on subform / combo box requesting parameter 0
How to update the data of a combo box 1
combo box, select all 4
Multi Combo boxes for 1 subform 6
Combo Box Look Up 3
Limit combo box entries in a subform Access 97 2

Back
Top