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

"Thomas" wrote:

> 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