I'm trying to find code that will check to see if a record is in use
prior to opening a form based on that record in a multi user
enviroment, if I can do this check, and if the record is in use, I
will have it open the form as read only. I currently have "edited
records" locking enabled on the form, which is working as I want, but
because of the enviroment I have had to disable most of the controls
inside the form that would let you exit the form in a locked
situation, which is leaving people locked inside the form until the
person editing the record gets out. If you know of code that will let
me check if a record is open, please let me know.

Thanks,

Glen