subform requery

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 17 Jul 2007 13:38 GMT

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.

Reply to this Message

Douglas J. Steele - 17 Jul 2007 13:52 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>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
[quoted text clipped - 7 lines]
> 2nd
> combo box.

Reply to this Message

Dan - 17 Jul 2007 16:12 GMT

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
[quoted text clipped - 11 lines]
> > 2nd
> > combo box.

Reply to this Message