Is it possible to display data in a combo box that's not available as
one of its drop-down options?
I have a healthcare database that tracks patient appointments and the
attending doctor. The doctors are listed in a combox box that's
supplied by a table (tblDoctors).
If a doctor quits, we need to display their previous appointments with
the patient in the combo box, but not have them available as a choice
for future appointments. I tried to accomplish this by creating a
field called "Inactive" in tblDoctors, and making this a criterion in
the combo box's row source area. That eliminates the former doctor as
a choice, but for their previous appointments, the combox box is
Can anyone suggest a way to correct this programmatically in Access?