Hi everyone,
I have this code
Dim ID As Long
ID = QuoteID
DoCmd.GoToRecord , , acNewRec
location = DLookup("location", "tblSeller", "QuoteID=" & ID)
UserFK = DLookup("UserFK", "tblSeller", "QuoteID=" & ID)
cmdClose.SetFocus
works really well. It opens a new record...