I think you're going to need to provide even more details than that.
Are you saying that when you open a form, not all of the data appears?
Where's your data: in the same database, in another Jet database on a
server, in some other DBMS?
What version of Access? What OS on the client? What network?
Refreshing the data makes it available to other users, but it doesn't
requery their forms. Each user must requery his/her own form to get the
lastest changes. OTOH, it is rare that 2 users are working on the same data.
I have 51 concurrent users on one system, over 30 of which are editing data.
I can't remember the last time there was a record conflict.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads http://www.datastrat.com http://www.mvps.org/access
Running Access 2003 on Windows Small Business Server 2003.
I am updating controls on a subform based on updates in the main form. The
updates in the subform do occur, but sometimes it takes 10-15 seconds
(sometimes more) to show on the screen. I thought that by reducing the
Refresh Interval would solve the problem.
I tried using Me.Requery - but am presented with the following problem:
The Subform is linked/tied to the Main Form via CustNumber. When I run the
requery (via the Update event), the Subform always brings up the first
CustNumber record in the underlying query. I want the Subform to stay at the
current CustNumber record.
If I do nothing (that is remove the Me.Requery), the Subform does stay at
the current CustNumber record - it just can take a very long time to populate.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
