Avatar of Heather_D
Heather_D
Flag for United States of America

asked on 

Access Submit button grayed on new record

Greetings:

Currently I have the submit button disabled on a form if the user when to a new record.  This works, but the problem is that the user may need to go back to the record to add information.  Ex: Time In and then later go back the form to add Time OUt.

Here is my code:
Private Sub Form_Current()
Me.Command127.Visible = True
If Me.NewRecord = True Then
   Me!Command127.Enabled = True
Else
   Me!Command127.Enabled = False
End If
End Sub

How can I get the submit button to become disabled only the account has been closed?  Right now I have a account closed check box, and also a closer initial field.  I thought I might be able to use them but that is not working.

THanks,

Heather
Microsoft Access

Avatar of undefined
Last Comment
Heather_D

8/22/2022 - Mon