I have a form with two uneditable continuous subforms. The records on the subforms can be added, edited and deleted through a pop up detail form. When I click the delete button on the detail form, I run a delete query, close the detail form and requery both subforms. The problem is when the form with the subforms regains the focus the recordset is positioned at the record following the one just deleted. All the records preceding the deletion point appaer to go away. The user must scroll up or reload the form to view them. Many users panic thinking they've lost data. Is there any way I can have the form display all records after the requery?
Lost records requery
- Thread starter mikemaki
- Start date
