Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Locking record when form loads

Status
Not open for further replies.
Rene1024

Rene1024

MIS
Jul 24, 2003
142
US
Hello,

I have a split database application where users pull up records and do data entry on. I would like to write a piece of code that says that when the form loads the record that comes up is automatically locked so that no other users can bring up the same record.

How do I accomplish this?

Rgds.

Rene

 
Sort by date Sort by votes
Have a look at this thread - thread181-1283568.

I use it sucessfully every day.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
612
Kennelbloke
Kennelbloke
Moss100
  • Locked
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
281
Moss100
Moss100
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
329
Moss100
Moss100
Zyborg
  • Question
Using a variable as reference to a form
Replies
5
Views
269
Zyborg
Zyborg
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top