Hello,
I have a subform in my database in datasheet view. This is subform is located on a main form (let's call it Form 01) along with a text box to search and filter one of the fields on the subform. When a user double clicks on a record on the subform, another form (call it Form 02) pops up. This Form 02 has fields to show the record data user clicked on and some additional information. My issue is, every time I double click on a record on the subform, that specific record replaces the first record in the subform. I checked the code and I am not updating any data fields on the subform. Can you please help?
Thank you!