Drop down menu help

[whojstall11]

Ok im try to have a form that has multiple fields and two of the fields Medications and Dosages to have drop down menus. what i want to do is make a form to have my medications table have a drop down menu then once I pick a medication in the Medications table it will take me do a certain group of dosages in my dosages table.

Medications	Dosages
Nexium	10 mg
Nexium	20 mg
Nexium	40 mg
Prevacid	3 mg/1 ml
Prevacid	15 mg
Prevacid	30 mg
Prilosec	20 mg
Prilosec	40 mg
Prilosec	2 mg/ 1 ml
Zantac	75 mg
Zantac	150 mg
Zantac	15 mg/ 1 ml
Reglan	1 mg/ 1 ml
Reglan	5 mg
Reglan	10 mg

[RuralGuy]

Maybe this link will help: http://www.fontstuff.com/access/acctut10.htm

[June7]

Why do you have two tables? Does the medication table have more info then just the medication name? Need a table with fields for Medication and Dosage. Then you can build dependent (cascading) comboboxes. Check tutorials at http://datapigtechnologies.com/AccessMain.htm especially the 3 on comboboxes in the Access Forms: Control Basics seciton.

[whojstall11]

ok thanks guys that kind of worked. Now instead of changing one row it changes all of the rows in my whole database. here is a link of my screenshot

[RuralGuy]

You are describing a field in a continuous form that has no ControlSource (unbound). Could that be the case?

[whojstall11]

ha ha duh i knew that it works lol thank you!!!!!!!!!!!!!!!!

[RuralGuy]

Great! Did you notice that I attached your ZIP directly to the post? We currently do not allow BitMaps so it needed to be zipped as you did.