I have an application that is using BatchUpdates to update a linked SQL Server table. It works fine and the data is captured quickly BUT on closing the dialog used to set up the data, the main form is refreshed using Me.Requery

At first, this was only run if a flag was returned from the dialog but I have now made it unconditional. the records show up in Debug mode and sometimes in Run mode but usually they will not show up until I have navigated away and back into the form.

Infuriating.

Anyone got any ideas?

Cheers,

P.