Drop down box populates other fields

[skawes]

Ok so I am wanting to do something that I imagine is pretty simple, I want to have a form with one drop down box and 3 fields. The drop down box will list a series of numerical codes from a table. I want it so that when you select a number from the drop down box, the other 3 fields (Description, Symptom, Solution) will populate with the form with the information for these 3 fields from the table.

I know how to run a query doing this, but the last 2 fields contain to much information to be easily viewed in the query window. How can I accomplish this? I hope my description has not become horribly confusing, it sounded better in my head.

 

[gschimek]

I think you'll want to use Cascading Combo Boxes. I had a similar question a while back, and found that there's a lot of info already out there about them (once I knew what they were called). Just do a quick search.

 

[RuralGuy]

Bind your form to the table with the Code, Description, Symptom, and Solution fields in it. Bind three controls to the Description, Symptom, and Solution fields but not the Codes field. Now add a ComboBox control to the form and select the third option from the wizard. Done.

 

[skawes]

Bind your form to the table with the Code, Description, Symptom, and Solution fields in it. Bind three controls to the Description, Symptom, and Solution fields but not the Codes field. Now add a ComboBox control to the form and select the third option from the wizard. Done.

That worked perfectly, and it was so simple I am almost ashamed I wasn't able to figure it out on my own. Then again my work has me doing this stuff even though I haven't had any actual training on this stuff. Thanks again, I appreciate it!

 

[boblarson]

Then again my work has me doing this stuff even though I haven't had any actual training on this stuff.

That's all too common, believe me.

 

[RuralGuy]

Glad I could help.