Cascading Comboboxes

  • Thread starter Thread starter TimJames
  • Start date Start date
T

TimJames

I have posted another question earlier that introduced me to the concept of
cascading comboboxes that will either 1) filter records based on my selection
of my first choice or 2) self-populate a form based on the first selection in
the form. I have looked at various sites for examples and how-do's (IE,
MVPAccess, utteraccess, allenbrowne, etc.) followed steps and instructions in
tutorials but just am not grasping how to set up such a feature. Can someone
tell me where I might find a "How To" that starts right from scratch and
gives good clear instructions for each step that will enlighten a total
Access Newbie like me?

Thanks,
Tim
 
Hi Tim

I assume you have a form called MyForm

Open MyForm in design view
Create 2 blank combo boxes
Right click the 1st combo and open the properties box
Select the data column
Select the Row Source type row - insert Table/Query
Select the Roe Source row - select the build option (...)
This will open a query builder
Create the query with the infomation you want to show in the combo
Save
Right click the 2nd combo and open the query builder
Cteate a query
"you must include the bound field of the 1st combo"
VERY import that bit
Add the other linked data

In the column with the linked bound field (from the 1st combo)
Select the criteria row
Right click and select build
Use the wizard to select the form
Use the wqizard to select the first combo
Press "add"
Save

Your combos will now casscade

HTH
 
TimJames said:
I have posted another question earlier that introduced me to the concept of
cascading comboboxes that will either 1) filter records based on my
selection
of my first choice or 2) self-populate a form based on the first selection
in
the form. I have looked at various sites for examples and how-do's (IE,
MVPAccess, utteraccess, allenbrowne, etc.) followed steps and instructions
in
tutorials but just am not grasping how to set up such a feature. Can
someone
tell me where I might find a "How To" that starts right from scratch and
gives good clear instructions for each step that will enlighten a total
Access Newbie like me?
Click to expand...

I have a demonstration example, but no "tutorial text" at
http://accdevel.tripod.com/dwnindx.htm, choose the download entitled "Query
By Form With Three Combo Boxes". If you want to locate a record using just
one Combo, the Combo Box Wizard has an option you can choose and it will
lead your through the necessary steps.

Larry Linson
Microsoft Office Access MVP
 
Back
Top