Link a menu Tab to a subform (Combo Box)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alimbilo - 14 May 2008 18:58 GMT

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

Reply to this Message

Damon Heron - 14 May 2008 21:22 GMT

Place the subform on the form and set its visible property to false.
In the afterupdate event of the combobox, enter:

If yourcomboboxName.text= "Age" then
me!yoursubformName.Form.Visible= true
else
me!yoursubformName.Form.Visible= false
end if

HTH
Damon

> Hello,
> How can I link a sub menu Tab (in a combo box) to open a subform?
[quoted text clipped - 6 lines]
>
> Thank you

Reply to this Message

George Nicholson - 17 May 2008 15:33 GMT

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)

Signature

HTH,
George

> Hello,
> How can I link a sub menu Tab (in a combo box) to open a subform?
[quoted text clipped - 6 lines]
>
> Thank you

Reply to this Message