form refresh problem

[ovello]

I have a form with linked fields. If I keep this form open and I input the data in the linked table using another method, but not the form, the form is not refreshed. I would like to add a button to the form that refresh the form with the new data, but I dont` know any functions or VBA code that can do that. How can I solve this problem? There exisist any refresh form function/method in VBA?

Thank you in advance!

 

[freakazeud]

Hi,
I'm not really sure what your set up there is and what you actually trying to achieve with this, but yes there is a refresh method syntax.
To refresh the current form (where your button is clicked on) you can try any of these:

Me.Requery
Me.Refresh
Me.Repaint

Me.requery is probably all you need as it covers most of the scenarien.
If you want to refresh the form from somewhere else you need to reference that form e.g.: Forms!YourForm.Requery
HTH
Good luck