View Single Post
  #3 (permalink)  
Old January 16th, 2007, 01:23 PM
donevco donevco is offline
Authorized User
 
Join Date: Nov 2006
Location: Evergreen, CO, USA.
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your reply, Mike.
I moving from being a casual Access user to having responsibility for creating an application from scratch. I am very experienced in system design and databases, but new to VBA and the technical aspects of Access.

The form is a personnel update. It contains several combo boxes to select, for example, the person's manager. I would like it to work like Quicken, where you can change a record, but must click a control to perform the update. If I understand your notes, it would work differently.

 I could have all the controls and text boxes locked, and use a control click to unlock them. Then, any changes would update the record. I would lock the controls again when the user moves to a different record. Also, all would be unlocked when adding a new record.

I have a problem interpreting the events, and selecting the right one for the action