after update event help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
cheers

Douglas J. Steele said:
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.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


scubadiver said:
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.
Click to expand...
Click to expand...
 
Back
Top