Form Dynamic Update

[jimmyCRACKcorn]

I have a form that uses a recordset as its recordsource (all good). When two users are looking at the same record and one of the users deletes the record, the recordset of the user who deleted the record is updated but the other user can still see that deleted record. I have the recordset cursortype set to adOpenDynamic but still no update. I also understand that the recordset is cached locally but what good is that and how do i get around it.

How do i get forms to update dynamically on update, change, delete etc...


Thanks is advance