Clear Form and All lock outs on button click 
Author Message
 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,



Mon, 18 Aug 2008 05:57:31 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Locked buttons change size on clicking

2. Outlook 2002/XP excessive logons to Exchange Server - cause lock outs

3. excel lock outs

4. Multi user lock outs...

5. Clicking a command button on one form from a different form

6. Form Location after Clicking Form's Restore Button

7. Reset/Clear Form Command Button

8. Access Forms and Clear Command Button coding in VBA

9. Clear form button

10. Submit Button and clear form


 
Powered by phpBB® Forum Software © phpBB Group