Updating data within a form/table.....

[softspoken]

Ok I have created a database, split the database, and provided multiple users with the Front End copy of the data. Everyone is keying in the form and adding records to the table.

I have a little problem.

One user will key in the bulk of the information but another user will need to finish the record. I have a "Find" command button on the form for them to be able to look up a record number but the problem is:

The user that needs to finish the record cant see what the inital keyer has keyed until she goes all the way out of the database and back in.

Is there a refresh button somewhere that will allow all the users to see all that data that has been keyed in at that point? I hope thats clear enough.....

(Access 2003 )

[pbaldy]

The method would be to requery the form. Before the rest of your code in the "Find" button try adding:

Me.Requery

[softspoken]

That worked perfectly ... thank you so much for your speedy response.

[pbaldy]

Excellent, glad it worked for you.