Updated data confirmation

[benett]

Background: In a form I send a record (or edit an existing one) to a table. Directly after this I requery a subform to the form, this is done to see changes in the table (the subform is based on the table). This worked just fine when i had the table in the same db. But since a split the db and placed all tables on a server it doesn´t... The problems seems to be that the requery command runs to early, before the "server-table" has recived the data.

Right now a use a cmd button to manually update the form, and I have notice that it could take 2-3 secs before the data is recived. This is NOT a very beatiful solution!

So what I need is a way to see when the data is recived and the table is ready to be updated... I use VBA...

Regards Johan Benett, SWEDEN

 

[DougP]

You could also put a pause statement in


Your code to get the records
‘
‘
‘
Dim sngTime As Single
sngTime = Timer

' Wait five seconds.
Do While Timer - sngTime < 5
Loop

Me![Subform].Requery

It works very well.
DougP, MCP