subform requery

[Guest]

I have an unbound form with 2 subforms on it (customer info and site info).
Each subforms is linked to a combo box on the main form. When I select a
value from the 1st combo box (customer), it requeries the second combo box
and displays customer info on the first subform. When I select a value from
the 2nd combo box (site), the site data displays on the 2nd subform. That all
works. However, when I change the value in the first combo box, I want the
2nd subform to go back to being blank until a value is selected from the 2nd
combo box.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...56515a73637f&dg=microsoft.public.access.forms

 

[Douglas J. Steele]

You must have code in the AfterUpdate event of the first combo box. Put code
there to hide the 2nd subform, and make it visible in the AfterUpdate event
of the second combo box.

 

[Guest]

Perfect! Thanks Doug

You must have code in the AfterUpdate event of the first combo box. Put code
there to hide the 2nd subform, and make it visible in the AfterUpdate event
of the second combo box.