Open SubForm based on ComboBox selection

C

Claude

Greetings

My platform is Access 2000

I have a Parent Form containing 3 SubForms (Form1, Form2, Form3) all set at
Visible = False (Not visible in Parent Form)
I then have a ComboBox with 3 Lookup fields (Field1, Field2, Field3) in the
Parent Form.

I am unable to Code the following:
When selecting "Field1" in ComboBox Lookup, Form1 must be set as "Visible =
True"
When selecting "Field2" in ComboBox Lookup, Form2 must be set as "Visible =
True"
When selecting "Field3" in ComboBox Lookup, Form3 must be set as "Visible =
True"

Is this at all possible??, if so, some sample code would be greatly
appreciated.
Thanking you in advance
Claude
 

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

Open SubForm based on ComboBox selection 2
Subform unable to present Query Output ? 0
Setting a parent form value based on a subform entry 0
Copying Forms From One Database to Another and Back Changes Them 4
Different fields "Required" 1
Lookup current record with ComboBox, any changes create new record 3
populate a combobox based on unique values in another workbook 16
How hide combobox without selection? 8

Top