The SAVE button on one of my Forms does a validation check before saving the contents of 3 unbound text boxes.
When there is already a record in the table with values identical to the contents of the first 2 text boxes, I use a Msgbox to ask the user if he/she wants to replace the value of the existing 3rd field (already in the table) with the contents of the 3rd unbound text box.
I've been using Dlookup to determine if there is already a record in the table that matches the values of the first 2 text boxes.
But I'm not sure if I should continue to use Dlookup to get the focus on the record that a user might want to change.
Should I be using something like Search For Record? Or something else?
When there is already a record in the table with values identical to the contents of the first 2 text boxes, I use a Msgbox to ask the user if he/she wants to replace the value of the existing 3rd field (already in the table) with the contents of the 3rd unbound text box.
I've been using Dlookup to determine if there is already a record in the table that matches the values of the first 2 text boxes.
But I'm not sure if I should continue to use Dlookup to get the focus on the record that a user might want to change.
Should I be using something like Search For Record? Or something else?