IM Lost on my form

[whojstall11]

I making a database so that user enters in gerenal information then im trying to make a drop menu that has a list of medications then user is able to choose multiple medications then the user is prompt to enter in the dosage, rountine, and then Frequency but im have a hard time doing this. Can somebody please help

 

[CBrighton]

I am guessing that someone with multiple medications will have multiple dosages, routines & frequencys?

How are your tables setup, I assume it is a many to many relationship between a patients table and a patient medication table?

Chances are I'd have a form bound to the patients table with a group of unbound controls (or possible a popup form with unbound controls) including a single-select combobox and some input boxes for dosage, etc plus a command button which will create a record in the patient medication table. I'd also have a subform on the patient form showing all records in the patient medications table for that patient.

However, with the limited info you have provided it's hard to say for sure.

 

[whojstall11]

Yes it will be for multiple dosages, routines & frequencys. But i also have dropdown menus for for the dosages and frequencys. Attached is what it looks like

 

[CBrighton]

Sadly I only have access to access 2003 on this workstation, so I cannot open accdb files.

 

[whojstall11]

No worries try this one PLEASE

 

[CBrighton]

Attached is an updated example.

It's not 100% complete (I had to rebuild your dosage tables and couldn't find a source for things like your list of possible medications) but check the structure of the new tables & the VBA behind the form.

I'm sure you can understand enough from my example to do the real thing yourself, if not just ask any further questions here.

 

[whojstall11]

Yes thank you this is the new one but in the subform it wont let me enter in multiple data im pretty sure its many to many but not sure how to change it.

 

[CBrighton]

You have set MRN in the medications table as no duplicates, so currently you can only have 1 medication per person (I didn't notice that).

Remove that and it will let you save multiple medications per person.

It's 1 patient to many medications, the drugs & dosage tables are just reference tables which need no relationship.