HOW TO REFRESH THE FORM WITHOUT EXITING THE FORM

[rajput]

Hi, here is what I am doing now I have 2 users who are inputing the data and 1 user updating the data that other two have entered. Now every thing works fine, if the data has been entered before the update data user opens up the form. After the update user opens up the form the new data that is been entered by other 2 data entry people is not available till the update user exits the form and opens the form again.
Now my question is this, is there a way that the update user does not have to exit the form but still can access the recent entries made by other data entry users. I am using Access 2K and I have tried Me.Refresh and Me.Requery but still it does not work.

Thankx for taking the time to read. I will appricate any help that I can get.

Rajput

 

[Mendel]

I'm not sure if what I was working on is similar to yours but I had trouble refreshing my form and found the answer from previously asked questions about refreshing forms on this site.

I found that instead of writing code to refresh the form, create a macro with the action "Requery" and then type in the name of the control on your form. Then create a refresh button on your form which executes the Refresh macro.

HTH

Mark