Controlling Edits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that is used by 6 admins;unfortunately, they are having some
difficulty remembering to search for the records before updating info.
Which, of course, means they are overwriting data that is still valid. How
do I change my form so they will have to find the record and then hit a
button to edit. THANKS!
 
Here is a technique I used once for a similar problem.

Put a combo box in the Header section of your form for them to use for a
lookup.
Put all you command buttons in the Footer Section so they will always be
visible. One of them should be a Save or Update button.

Now, in design mode, make all your data controls in the detail section
Enabled = False and make the Detail Section of the form Visible = False.

So now they can see nothing until the make a valid selection. In the After
Update event of the combo if they have selected a record to work with, Enable
the data controls and make the Detail section visible.

Remember the Save button? In it's click event. Update the record (Me.Dirty
= False), disable the controls and make the Detail Invisible.

I also included an Add button that positioned on a new record, enabled the
data controls and made the Detail invisible.

You don't want to provide Navigation buttons using this technique.

Now, if you don't want to get that drastic, another way would be to lock all
the data controls and let them unlock them using an Edit button. Disable
them again using the Current event of the form.
 
Back
Top