Form Refresh 3

[gabriellec]

Need a little help with refreshing data on a form. The situation is: Form A is the parent form with a button which launches Form B. After the user enters the information on Form B and closes it (which Form A remains open in the background) I need Form A to refresh.

Anyone have that simple line of code to put in the VBA for Form B?

Thanks.

 

[LonnieJohnson]

Try this in FormB's Close event

Forms![FormA].Requery
Forms![FormA].Refresh

B-) ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[tlbroadbent]

Include one of the following in the Close event of FormB.

[forms]![formA].Refresh ' refresh the data on the form
[forms]![formA].Requery ' requery the data source Terry

X-) "I don't have a solution, but I admire your problem."

 

[gabriellec]

The refresh/requery works great. Only one issue. When I get back to Form A I go back to the first record. Anyway to keep it at the record I left it in?

 

[Jaco]

You have to remember somwhere .bookmark property and, after requerying/refreshing the form, you should set it.
For example:

dim varBookmark as Variant

varBookmark=forms!form_A.bookmark

...


forms!form_A.bookmark=varBookmark