Nice - that shows how to display the data
On a button press event - how do I determine if I need to insert the data or edit the data?
For example, I found this that will allow me to insert data into the database from the form but how do I verify that I am not inserting when I should be editing?
Code:
Private Sub btnSaveToDatabase_Click()
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset("tblUserInfo")
rs.AddNew
rs!UserID = Me.UserID
rs!Birthday = Me.Birthday
'more fields...
'more fields...
'more fields...
rs.Update
End Sub