-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You'd have to set the "Default record locking" option on the:
Menu bar Tools > Options > Advanced tab
to "Edited record."
- From the Access Help article "Set options for a shared Access
database":
"This setting takes effect the next time you open the Access database,
but you must use the Open command on the File menu rather than the
list of most recently used files at the end of the File menu."
Set the same property (a ComboBox) in a Query's (Design View) Property
dialog box.
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQAckNYechKqOuFEgEQLbawCgr2rMwJZGm9wEI6IoMd7Qpn H1GAMAoPry
/USzqF2ibfYTCRZwxnm+Bek3
=CYro
-----END PGP SIGNATURE-----
David Ehrenreich wrote:[color=blue]
> Hello,
>
> I have my Database setup with a backend and several instances of the
> same form in a frontend linked to the backend tables. Their are
> several of these frontend stations. What I like to do is when a user
> is working with a record another user on another station wont be able
> to enter into that record for editing. I would like a message box to
> appear telling the user to try again at another time. I was told
> about EditMode Property function, but i'm a little clueless on how to
> use it. I don't even know if this is the right way to go. Any help
> with this would be great.
>
> David Ehrenreich[/color]
