#deleted record in multi-user environment help!!!

[ruyeno22]

Hi:

when 2 users are accessing the same form, and one deletes a record, the other user gets a #deleted in the row where the deleted record used to be.

this is very annoying, can anyone tell me how to get rid of that???

thank you very much

 

[ruyeno22]

please help!!!

 

[Lozere]

One turnaround is to refresh periodically (Me.Requery) the form in a timer event procedure

 

[THoey]

I don't believe you can change that. Unless there is some way to tell Access to refresh the query everytime someone else makes a change, and I think that would be more of a bother to a user than seeing a deleted row... Terry M. Hoey

 

[ruyeno22]

You are both right.
using the timer is a solution, but it all depends on the interval.
if i set it to 1 second, i think the performance will be damaged.
if i set it to 15 seconds, for example... the user will still see the #deleted for some time, before it disappears..

still looking for an answer....

 

[ruyeno22]

Just trying to keep it in the first list... i really need help, cause my boss does not want to see this #delete thing.