DATA ENTRY USING A FORM VIA NETWORK

[Vic]

If anyone can give me an answer I would really appreciate
it. Totally frustrated with this one. Here's the problem.

Example:

User A opens the database at 10:00am.
User B opens the database at 10:00am.

User A enter data in a form at 10:05a through a form.
User B does a search using the same form at 10:10a of the
data User A just entered. The system says there's no
records for that specific data.

Now if you close the form and do a search again the data
that it said wasn't there is now there.

The network setting are totally correct. If you delete a
record it immediately appears on the other persons unit.

I've gotten an article from Microsoft title View the lates
records for a form programmatically but the instructions
on that don't work either.

I'm ready to pull my hair out.

Can someone please please help.

 

[Allen Browne]

Not interested in posting answers to as many groups as you posted this
question to.

 

[John Vinson]

If anyone can give me an answer I would really appreciate
it. Totally frustrated with this one. Here's the problem.

Example:

User A opens the database at 10:00am.
User B opens the database at 10:00am.

User A enter data in a form at 10:05a through a form.
User B does a search using the same form at 10:10a of the
data User A just entered. The system says there's no
records for that specific data.

Now if you close the form and do a search again the data
that it said wasn't there is now there.

One suggestion would be to put a Command Button on the form which
simply Refreshes the form:

Private Sub cmdRefresh_Click()
Me.Refresh
End Sub

and train the users to click this before running a search.

Note that if User A has not yet actually saved the record (by closing
the form, or moving off the record to some other record) it won't be
there for UserB to find, though UserA will justifiably say "But it is
there! See, it's right on my screen!" <g>

A point of newsgroup etiquette: I realize that you're frustrated, but
still... please, *crosspost* rather than *multiposting*. Put a few (in
this case, I'd say .forms and .formscoding at most) newsgroup names in
the Newsgroups line and post once to all the groups, rather than
posting the same message separately to many groups. That way the
volunteers who donate their time to answer questions won't waste that
time (as I suspect I'm doing right now) answering a question which has
already been asked elsewhere. Thanks!