There is no reason why multiple users accessing a shared back end database could not view data entered by others. If someone has a form open, that form has a recordset that was created when the form was opened. That recordset will show data changes and deletes made by other users after the automatic refresh happens. This is set to 60 seconds by default I think although the user can choose Refresh from the Records menu to to see the changes. Neither of these refreshes will show data added since the form's recordset was opened.
If your users leave forms open for long periods of time and during that time others may add records that they need to see, you need to give them a way to Requery the form. Requery does exactly what it says - it reruns the form's RecordSource query so it will retrive all added records in additon to any changed records. Add a button to the form and train the users to press it periodically when they want to "see" data entered by others. Keep in mind that when you requery a recordsource, the recordset is repositioned to the first record. If your users are going to find this disturbing, you'll need to save the current record and after the requery, use the RecordsetClone to reposition the form back to the record the user was on. In the click event of the button, the minimum you need is:
Me.Requery
It is possible to do this automatically in the timer event of the form but I don't recommend it. Using timer events has a tendency to make the form flicker ever so slightly. There are other potential pitfalls especially if while testing you make a mistake and edit an object while some open form has an active timer event. This frequently will corrupt the database.
