Search results for query: *

This post is related to thread705-612488. This is what I want to do. 1. Delete a record. 2. Requery the form. This shows the first record of the set. 3. Go to the record after the one I just deleted to continue viewing records. e.g. I delete Smith, John (record number 97 lets say). After...

Thanks to all who responded. I was able to make this work using Mainform/subform with the find dupes query as the recordsource on the mainform and a query based on the above query but where it equals the SSN on Main and does not equal the RecordID on Main. It will need some tweeking. Thanks again

Thanks for the response. I am trying to create (a) form(s) that will show side-by-side 2 duplicate records and enough data to distinguish them. The user would then decide which record to delete. Any records related to the record to be deleted would have to be transferred to the remaining...

Is there a way to view duplicate records side by side on a form in Access? Something like a continuous form sideways?

Thanks for the reply. I was not able to find the Record Delimiter, as opposed to a field delimiter, in the Export Specification. Where can I find the Record Delimiter specification? Bob

I was wondering if there is a way to change the record delimiter on export to other than HRt i.e. []Hrt.