snerting
Programmer
- Oct 20, 2005
- 52
Hello
Due to the structure of the database and how our meta-data versioning of the data works, I have to do a requery on each form after update. I'm not allowed to call Me.Reqery in the "AfterUpdate" event, so I didn't see any other way of doing it than put the requery in a timer (if afterupdate had been run, the timer would requery, otherwise it would just return). I don't really like timers to be honest, and now they have started behaving badly, causing errors (ODBC call failed etc) when swapping records.
Is there _any_ way I can perform a Requery (which isnt asynch) after doing an update? What I'd like is typically an event that is called after the complete update transaction.
Due to the structure of the database and how our meta-data versioning of the data works, I have to do a requery on each form after update. I'm not allowed to call Me.Reqery in the "AfterUpdate" event, so I didn't see any other way of doing it than put the requery in a timer (if afterupdate had been run, the timer would requery, otherwise it would just return). I don't really like timers to be honest, and now they have started behaving badly, causing errors (ODBC call failed etc) when swapping records.
Is there _any_ way I can perform a Requery (which isnt asynch) after doing an update? What I'd like is typically an event that is called after the complete update transaction.