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 SkipVought 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
0
0
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
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
169
Kennelbloke
Kennelbloke
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
133
Moss100
Moss100
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
129
dhookom
dhookom
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
132
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
145
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top