> Any help or tips will be much appreciated,

Have you checked the BufferSynchroFlags of the query? I thought they
operated as you require.

If that does not do what you want perhaps you can solve the problem by
using two datasets querying the same table. One being the master
dataset that has the specified search critieria, the second setup as
the detail (one-to-one since it is the same table) that is used for
editing. That way you can refresh the detail dataset without
refreshing the master - and since the linkage would be just the
primary key your record should still appear.

HTH

Geoff Worboys
Telesis Computing