Solved

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

Posted on 2012-12-29
2
456 Views
Last Modified: 2012-12-29
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
0
Comment
Question by:peispud
2 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 38729109
Can you post your code, or a sample database?
0
 

Author Closing Comment

by:peispud
ID: 38729121
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
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question