Access 97 Requery

[paulw]

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.

[JemimaChadwick]

hi P,
I don't get wat ur requirement is...do u mean to have the Me.requery triggered or something?

- Jemima.

[paulw]

Thanks for answering Jemima,

The problem is that the Me.Requery method is definitely running but it does not always refresh the form - is this a bug with BatchUpdates or what? The data is there so why doesn't the form refresh?

The code is correct but the App is behaving in a non-predictable way.

Cheers,

P.

[JemimaChadwick]

Paul,
jus an assumption. Cld it be that the batch update is still running while the form is being refreshed and that the table is not updated by then?
...do post in when u figure out wat caused it to be erratique!

-Jemima.