Unclear on who closes the form. If User B can't see the new record until User A
closes the form, then I would suspect that User A has not done anything to cause
the currently displayed (but not saved) record to be saved.
Try adding a button to the Input form that can be clicked when you are ready to
save the underlying data to the table(s).
Code would be
If Me.Dirty = True then Me.Dirty = False
See if that works to show the record. If not, post back and perhaps someone
will have an idea of the cause of your problem.
Also, what version of Access are you using? Is the data stored in an Access
database, SQL server, someplace else?
Vic wrote:
>
> 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.
|
Similar Threads
