can you capture more than 1 record in a combo box form field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am able to create a form where I can capture single items to the individual
record.
What I would like to do is capture more than one item e.g up to 4 or 6 per
record. Why? If for example a patient has more than 1 diagnosis or medication
I need to capture more than 1 code from agiven table and apply it to that
record.
e.g Diabetes mellitus
Diabetic nephropathy
Hypertension
[All these are in the same table Disease Code]
 
If you have a main form based on the Patient table (tblPatient) and a related
table for recording diagnosis information (tblDiagnosis), you can base a
subform on tblDiagnosis. Set the subform's view to continuous. You could
have a combo box on fsubDiagnosis (the subform) for selecting a disease code
from the disease code table (tblDiseaseCode). The combo box's row source
would be tblDiagnosis, or more likely a query based on tblDiagnosis.
Depending on the details of what you need to do you may want to use variants
of this approach.
 
Back
Top