Requery problem

[clmarks]

I have an Access 2003 database of client records. The data is in a backend and each of about six users have their own individual front ends. My problem is that if one user adds a new master record the other users cannot see it unless they exit the data entry form and open it again. The master records are called up by using any one of three comboboxes. I have tried putting an requery instruction in after the fields used in the comboboxes are updated, when the form is opened, and before each combobox is updated. None of these attempts worked.

Where am I going wrong? It seems to me that this should be pretty easy.

Thanks for any help.

Cherry

 

[Galaxiom]

The other users have to requery to see new records.

One way is to set a timestamp in another table when a new record is added.
Each user's front end is set to regularly check the timestamp and do a requery if it has changed since it last looked.

 

[clmarks]

Thanks for the tip. I'll give it a try.

cm