Looking for an event

[Lee Hunter]

I am modifying the rowsource in a list box. Is there an event triggered when
the record navigator is used that will allow me to restore the rowsource to
its original state? As you know, when the row source is modifed, a requery
automatically takes place.

The situation is this. I have two list boxes, one for part numbers and one
for commodity codes. I am using the list boxes to display all parts for a
given commodity or alternaticely to display the commodity for a given part
number. Each list box is filled from a separate input table and bound to a
separate field in the output table. The user can make a decision to use one
method or the other, select a given part number and commodity and write the
record. Then I need to restore the rowsource to its original state;
selecting all parts and all commodities.

Can anyone please suggest a solution?

TIA
Lee

 

[Sprinks]

Hi, Lee.

The form's OnCurrent event occurs when you move the focus from one record to
another.

Sprinks

 

[Lee Hunter]

Thank you, sir.

It worked just as advertised.

Much obliged
Lee