How do I refresh users forms to show all newly added records

[hollifd]

I have a front end and back end database setup. About 30 simultaneous users have a front end database that is looking at the data in the back end database. This has been working great for about 8 years now. One issue that I have always had is when a user adds a new record, it does not appear in the other users forms until they shut down and restart the form / database. There must be a simple way that I can refresh the records so that all users can see all records at all times. The form is based upon a select query that selects records from only 1 table.

What is the method of refreshing data in forms?

Thanks,

David

 

[petejm]

You could try an ontimer event

Private Sub Form_Timer()

Me.Refresh

End Sub

set the timer interval to whatever number you wish.

(1000 = 1 Second)

Regards

Pete