What Event?

[Guest]

I have a form based on a query. On the form I have a list box that is
independant from the form (it is based on a totally diffrent table and
query). Any time I navigate in the form I want to requery from one record to
the next I want to requery my list box. I know how to re-query but I can't
figure out what event to re-query on.

As always thanks for the help!

Robert

 

[Marshall Barton]

I have a form based on a query. On the form I have a list box that is
independant from the form (it is based on a totally diffrent table and
query). Any time I navigate in the form I want to requery from one record to
the next I want to requery my list box. I know how to re-query but I can't
figure out what event to re-query on.

The form's Current event fires when you navigate from one
record to another.

 

[Guest]

If you want to requery your list box each time you change the current record,
use the form's Current event.