Clear Form and All lock outs on button click

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

Guest

I currently have a code on the AfterUpdate event that will lock out certain
text/drop down boxes when a selection is made from the drop down box. I
placed a code in the OnCurrent update event that would clear all lock out
parameters. However, in doing so, it limits the ability to add a new record.

how do i code a Add New button do clear all lock out parameters and go the
next new record?

thank you,
 
I don't think you need an addnew button, You could do it in the Current event
with:
If Me.NewRecord = True Then
'Remove the Lock Outs Here
Me.SomeControl.Locked = False
Else
'Set the Lock Outs
Me.SomeControl.Locked = True
End If

If you already have an Add New Button, just add the same code to remove the
lock outs you would use in the current event.
 
Back
Top