Requerying subforms

  • Thread starter Thread starter ISD
  • Start date Start date
I

ISD

I have a main form with 3 nested subforms (A is main, B is a child of A
and resides on A; C and D also reside on A but C is a child of B and D
of C). The subforms are linked to their parents via the Parent and Child
links. Unfortunately, this setup requires that I force a requery of the
subforms (it seems to happen automatically if a child resides on the
parent). I would like to requery as soon as I click the navigation
buttons to bring up a new record (not necessarily on a change to the
record tho). Which event do I use? What is the syntax for the requery
method?
 
A form's Current event fires when you move from one record to the next.

--
Wayne Morgan
Microsoft Access MVP


I have a main form with 3 nested subforms (A is main, B is a child of A
and resides on A; C and D also reside on A but C is a child of B and D
of C). The subforms are linked to their parents via the Parent and Child
links. Unfortunately, this setup requires that I force a requery of the
subforms (it seems to happen automatically if a child resides on the
parent). I would like to requery as soon as I click the navigation
buttons to bring up a new record (not necessarily on a change to the
record tho). Which event do I use? What is the syntax for the requery
method?
 
Back
Top