I have a form that allows a user to go through all of the entries in a table as well as add a new entry to that table. On my form, I have a text box that I want to display only when the user is entering a new record. Is there VBA syntax that will allow me to do this? Thanks so much!!
Private Sub Form_Current()
'If this is a new entry Then <-- What is the syntax?
txtDate.Visible=True
'Else
'Don't show text box
'End if
End Sub
Private Sub Form_Current()
'If this is a new entry Then <-- What is the syntax?
txtDate.Visible=True
'Else
'Don't show text box
'End if
End Sub