I am hoping someone may be able to help me program Access correctly.
I want the ability for the user to click on a checkbox, enter a new record, and after adding that record, have some of the same information already entered. If the checkbox is false, then the user will simply enter a new record, and all fields will remain blank for the next record.
I did the following -
Private Sub Name_Exit
Data1 = Me.Name.Text
Private Sub Form_AfterUpdate()
If me.checkbox1.value = True Then
Me.Name.Text = Data1
When I do this, it will not save the record.
Any thoughts on what I should do differently? Thank you for your help.