Auto Refresh Help

[shebr19]

Hello,

I have created a Table and a Form for entering people details which is accessed by several users through our server. The only way I can get one computer to see records entered by another user when the form is open is to hit f5. I have tried me.requery which updates the information in the form every 20 seconds but when this happens, it returns you to the first record. If your in the middle of entering a new record and it performs a requerry, you start to edit the first record. Is there just a way to replicate the refresh of F5?

Thanks

 

[Insane_ai]

Create a data entry form separate from the master list. When the data entry form is closed, trigger the refresh of data on the list form.