Access 2010 field receiving vba updates not revealing new info till requery or refresh

peispud
peispud used Ask the Experts™
on
Hi

I am using Access 2010.  I am using a continious form.

I have a field which gets updated via VBA.

The underlying table does receive the correct information, but the screen does not  display the new information (for this field) till I do a requery or refresh.  

I would like the user to see the new value that my code has put there while the user is still editing the record. I am hoping to do this without too much screen flicker.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Nerd
Most Valuable Expert 2012
Top Expert 2013
Commented:
Can you post your code, or a sample database?
peispudTech

Author

Commented:
I tried creating a sample database to demonstrate the problem.  I can't reproduce it there yet.

I'd like to give you points for this.  Your suggestion made me take a step back.

I may have to repost the question later but right now, I will re-write / examine my code.

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial