getting multiple users to see new records

[Zodiacal]

my database is used by multiple people on our network. if someone makes a new record the other people don't see it until they requery that form. the form is quite large now 30k records and the requery takes a long time (about 1 min). whats the best way to handle this? should i make the form only select the current record they need? its an order form btw. if thats the case the build in find feature will not work. right now this is the best way i can think of so im buliding my own find form to fix this problem.

[KnooKie]

yes absolutely. Filter the recordsets down. It will just get worse and worse if you do not.

Have a look at the Filter property of a form for filtering recordsets down.

However you may be wiser to filter down the recordset before the user opens the form or they will always be opening a large recordset prior to filtering.