Access has four methods that seem to be similar and often get new VBA users confused.Here is what each of the methods does, and how they are different. It goes to the database and runs the underlying query again. There is a textbox that has a formula that gives a total price (e.g. If you use recalc on the Lost Focus event of both quantity and price textboxes, you will recalculate the total price. Refresh Refresh is sort of like requery except that it only updates the records on the screen.
I hope this will make it clearer to people which method to use in which situation.
Tags: Microsoft Access Developer, Microsoft Access Development, Microsoft Access Help, Microsoft Access VBA, recalc, refresh, requery This entry was posted on Tuesday, August 17th, 2010 at pm and is filed under Uncategorized.
I've had a search and can't find anything along these lines...
For example, if you had a form which was used to add people. If someone has added another record in a multi user environment, it will not get display the new record.
On that form you had a combo box that listed people. The good thing about refresh is that it leaves the cursor where it was.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
What happens is that it grabs the sequence number, finds the next in sequence and gives it a new sequence number (existing number -1) and gives the selected record a new sequence number (existing number + 1).
I now need to resort them so can use refresh which leaves the cursor on the selected record. If I wanted to move down twice, I would have to find the record and select it again with requery. This is used to refresh the screen without interacting with the database. Say you have a label “Update Processing” to warn users that a lengthy process is happening.