The following code has been working perfectly, but suddenly I'm getting an error that focus can't be set on the PID control.
Code: Select all
Me.SelectPID = Null
SelectPID is a combo box. It displays all the PIDs alphabetically, with the patient names shown and the key field hidden. The bound field is PID and PIDs are indexed with no duplicates, so all are unique values. PID is a visible field set to not enabled and not locked.
I'm thinking there should be a better way to call the record, like maybe a recordset clone, but I'm posting to see if I can get a properly written, reliable procedure.
This applies to frmPatients and frmVolunteers in the same way.