> Before my main import routine, I prepare this query.

...

> What I was doing was to close the query, set the new param value,
> then call open.

...

> Could it be that the cursor was 'remembering' it's last position,
> even though I was closing then re-opening it?

Yes it does remember the parameter at the time it was closed.

You dont need to close a query to change the parameter (indeed,
as you have discovered you should not close the query just to
change a parameter). Just change the parameter and call First
to get the altered selection.


--
Geoff Worboys
Telesis Computing