Updating/refreshing form data 1

[postmanphat]

Hi,

I have a form (mainmenu) where the user can select a record from a list box, which then opens up another form (Items) showing the relevant information selected on the main menu. When the 'Items' form opens, the 'Mainmenu' form's visible property is set to false to hide it.

Once you've made the change to the data on the 'Item' form, you close it which in turn sets the 'Mainmenu' visible property to True so that it reappears. However, the Mainmenu form will still show the old info in the listbox from before you went in and edited it in the Items form.

I basically need to know how to refresh the form data upon being made visible?

Any help would as ever be greatly appreciated.

Thanks

Dave

 

[PHV]

What is your actual code making the form visible again ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jamaarneen]

Hi Dave,

You might try adding this line of code after making the mainform visible:

Forms![i]YourMainformName[/i].Requery

Helped?
Ja