I would like to know how I can add to a record using VBA. What I am doing is using a DLookUp
Result = DLookup("[LicenseNumber]", "MGNameAddressPhone", _
"[LicenseNumber]='" & Me.LicenseNumber & "'")
If Result = 1 Then
And if that returns a record (only one will return since the field can't have duplicates) I want then to add to that record data that is on my form. Not sure how I can call that through vba to add to that specific record that DLookUp found or not? It would be a separate field or fields within that table.