Avatar of peispud
peispud
Flag for Canada asked on

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

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
Microsoft Access

Avatar of undefined
Last Comment
peispud

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
mbizup

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
peispud

ASKER
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
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes