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

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]
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top