I have a main form with a customer id field and customer name - in the sub form I have all the sales for the customer - however say if a right hand click to filter on a selected product this works fine BUT when i take the filter off - it takes the user back to the very first record say aaa111

Are theories!!

Regards

Paul

This is unfortunately a 'feature' of filters in Access. I have a button on one form that opens the same form with the WHERE clause "[primarykey] = " Me.[PrimaryKey]. However that just substitites one filter for another.

Another possibility is using recordsets. Look at the code behind any 'Find the record based on the value I enter' command button and adapt it to pull up your current record.

HTH,
David R