View Single Post
Old August 26th, 2004, 02:34 PM
demivolt demivolt is offline
Authorized User
Join Date: Aug 2004
Location: memphis, tn, .
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default Record sharing by multiple users

Clerk A enters record 1 on a form bound to access table and then goes on to enter more records on the same form. Clerk B tries to look up record 1 by a non-key field on the form (say, last name) to enter additional data--she gets a "not found" even though Clerk A is no longer on record 1. Why? Record locking is set to "edited records." I have tried a DoCmd.Save acTable "TableName" on the "after update" event of the form and this doesn't work either. Your solutions or suggestions would be greatly appreciated.