Re: Is Record Open

Access does not expose this information to you.

It would theoretically be possible to use the Current event of a form to
write a record record to a logging table, and the Close event of the form to
indicate they've gone. Doing this for all users would involve considerable
extra network traffic and a fairly high chance of write conflicts as many
users scroll records.

If you are only interested in when a user begins editing the record (not
just viewing it), the logging form's Dirty event would be much better.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lee-Anne W via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx> wrote in
message
news:528513DF86F56@xxxxxxxxxxxxxxxxxxxx
>
> can anyone please point in the right direction for the problem i have
> below.
>
> i have a multiuser database and when 1 user opens the form to edit a
> record i
> want to be able to show a message box if another user tries to view/edit
> that
> same record that will prevent the form from opening.
>
> of course when user 1 has closed the record user 2 can then open it.
>
> any help ...
>
> thanks
> Lee-Anne


.