Solved

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

Posted on 2012-12-29
2
455 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

803 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