after update event help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scubadiver - 27 Nov 2006 14:59 GMT

The code I use for a cascading combo is: me.[field].requery.

In this case [field] is in a subform and the list is based on a combo in the
main form.

thanks.

Reply to this Message

Douglas J. Steele - 27 Nov 2006 15:03 GMT

Assuming that the code is going into the AfterUpdate event of the combo box
on the main form, you need to use:

Me![NameOfSubformControl].Form![field].Requery

Replace NameOfSubformControl with the name of the control on the main form
that contains the subform. Note that depending on how you added the subform
to the main form, the name of the control that contains the subform may be
different than the name of the form being used as a subform.

Signature

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

> The code I use for a cascading combo is: me.[field].requery.
>
[quoted text clipped - 3 lines]
>
> thanks.

Reply to this Message

scubadiver - 27 Nov 2006 15:55 GMT

cheers

> Assuming that the code is going into the AfterUpdate event of the combo box
> on the main form, you need to use:
[quoted text clipped - 13 lines]
> >
> > thanks.

Reply to this Message