1-M form does not show new records to other users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a simple table to table, 1-M form, which had a master and one detail record existing.

I had another user enter record 2 in the detail and move off the record, while I watched my screen. I never saw the new record. I did the same and she did not see my record. We both did Record|Refresh and that did not help. I could see the new records when I closed the form and reopened it.

How do Access developers create forms that show all existing and new recs to other users? The mdb is set to shared and no locks.
 
Michael Miller said:
I created a simple table to table, 1-M form, which had a master and one detail record existing.

I had another user enter record 2 in the detail and move off the record,
Click to expand...
while I watched my screen. I never saw the new record. I did the same and
she did not see my record. We both did Record|Refresh and that did not
help. I could see the new records when I closed the form and reopened it.
How do Access developers create forms that show all existing and new recs
Click to expand...
to other users? The mdb is set to shared and no locks.
There is no way for this to happen without you forcing a Requery on the
form. Closing and reopening the form is one way to do this. You can issue
the command...

Me.Requery

....but that will take the user back to the first record (just as closing
and reopening does). To prevent that you would have to grab the primary
key value of the record they were on, issue the requery, and then execute
some code to take them back to the record they were on before the Requery.
All of this could be executed on a timer, but I would advise against that
if the user might be in the middle of an edit when the code fired off.

If you were only interested in seeing new records in the subform and didn't
care about the parent record you could issue the Requery only for the
subform which would not affect the record being displayed in the Parent.
Again though you wouldn't want to do this on a timer if there is a chance
that the user might be making edits in the subform at the time.
 
Back
Top