Openning form

  • Thread starter Thread starter DDPEN
  • Start date Start date
D

DDPEN

I have a form that contains a drop down list. I would like
a subform to open when a particular value is selected from
the drop down list. Otherwise I would like the subform to
remain closed. The subform contains 4 fields which are
specific to the drop down value. Help is appreciated. dp
 
In the AfterUpdate event of the combo box, check for the criteria you
are looking for and open the subform using DoCmd.OpenForm method.
Pavel
 

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

Message from macro if a particular item on a list is selected 2
Macro doesn't work first time form is opened. 2
Forms and Subforms 5
Moving Subform to Tab Control 3
Main Form and two Subforms 2
How to always get the top level form reference, when calling from any subform/subform... 0
Select response from dropdown in field1, populate both field1 & fi 1
Pivot table/chart in subform - can't open Field List 3

Back
Top