Clear Form and All lock outs on button click
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.
Quote:
> 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,
