Hi, here is what we are doing now I have 2 users who are inputing the data and 1 user updating the data that other two users entered. However, if the data has been entered before the update data user opens up his update form the data will be available for him to edit but if the input users enter more data in there forms(same table) and update users has his form allready open it does not show up on the update users form, he has to close the form and re-open the form to get the new records. then it says at the status bar Record 1 of 5000. But again if the input users add record no 50001 and so on it will not show up at all till the update users closes his form and re-opens it. I hope i am making some sense.

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 records entered.

I will appricate any help that I can get. pl. go easy as I am new at this.

Thankx

Rajput


[This message has been edited by rajput (edited 02-19-2001).]

[This message has been edited by rajput (edited 02-19-2001).]

There are probably 10 ways to do this, so I will offer one.
Put a command button on the update user's form using the command button wizard.
Select Form Operations/Refresh Form Data.

When this is clicked, it should refresh.

Other opinions to follow !!........

Michael Abrams

I did try that, but it does not show the new record that was just entered.

Rajput

I have a button on my form that jumps to another form. When this is pressed it runs this command to refresh and save the record so that the jump form can use info from it... like a link... This would be a part of the code enterd in the "On Click" section of the button.

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70