Unanswered: Get #Deleted - runtime error 3329 in hidden form when opened
I have a form "Customers" that I open hidden when my database loads. I am doing this because the formhas subforms with data from different tables,and loads slow otherwise.
as I cycle through records, these subforms refresh - I have queries bound to the subforms to match the data to the [CustomerNo] field.
All works well, except when I delete records in the Customers table. Then = when I show the form, and scroll through records, I get a message saying record deleted by another user and there is text that says #deleted in all the textboxes...
how can I prevent this? I really like how fast theform appears when preloading as I am. If I requerythe form on activate, it alwas goes to the first record???