I have this code in an onclick event of a command button which I want to happen if the ReqForPickUpID does NOT already exist. ...
Dim RS As DAO.Recordset
Set RS = CurrentDb.OpenRecordset("tblAuthorizationFormData")
RS!ReqForPickUpID = Me.txtReqForPickUpID
RS!Name = Me.txtName
But if the ReqForPickUpID does already exist I want the values to be overwritten.
Can this be done?