what subform events should I use to requery listbox on a subform?

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

Guest

I have a subform based on a query that may pull multiple records. There is a
unbound listbox on the subform that queries another table based on the value
of a field on the subform. When I moved from record to record on the subform,
contents of the listbox should change because the value of that data field on
the subform will change.

Could anyone tell me what subform or form events I should use so that when I
press the next record navigation button, the content of the listbox will be
automatically requeried.

Thanks in advance.
thomas
 
Are you requerying your unbound listbox when you change records in the
subform? For example, in the subform's current event, is there a line of code
reading, Me.MyListBox.Requery

TL
 
Back
Top