Hi Everyone,

Not sure if you need some pictures, I can attach them if needed.
I have a main customer form which has the customer's locks they own displayed on a subform. The record selector on this Subform then sets the related Key History records and then displays that on another Subform. This is a continuous list form.

It all works fine together except the issue I have is whenever I update a record or delete something as my forms Requery, The record selector goes to the top of the list. This could be an issue going forward as when adding a couple of entries I would need to remember to select the right record again or end up adding the wrong History to the wrong Cylinder.

I have watched the RecordSet video but can't make it work on a Subform. I have tried a few things in my head but I couldn't fix it.

A nudge in the right direction would be very helpful.

Thanks