Combo Boxes that filter database

  • Thread starter Thread starter Katrina
  • Start date Start date
K

Katrina

i am in need of serious help. been working on this for so long, haven't been
able to figure out. My database is based on motors and there are over 10,000
entries. i am working in a split form so i can choose in combo boxes what
kind specs for a motor and then have all my choices of motors down below
(brand, company...). In the 1st combo box i have Phase.( i would like it to
only have 3 choice:1,3 & DC) Right now i have so many because it is based off
of the motor table, but if i base it off the Phase table(which only has the 3
choices) it just changes the information in the table doesn't filter it. Once
Phase is filtered there are 5 other comobo boxes that i would like to filter.
How can i get my combo boxes to filter my form. Do i need to use a macro.(not
sure how those work).. Please help! Thanks!
 
i am in need of serious help. been working on this for so long, haven't been
able to figure out. My database is based on motors and there are over 10,000
entries. i am working in a split form so i can choose in combo boxes what
kind specs for a motor and then have all my choices of motors down below
(brand, company...). In the 1st combo box i have Phase.( i would like it to
only have 3 choice:1,3 & DC) Right now i have so many because it is based off
of the motor table, but if i base it off the Phase table(which only has the 3
choices) it just changes the information in the table doesn't filter it. Once
Phase is filtered there are 5 other comobo boxes that i would like to filter.
How can i get my combo boxes to filter my form. Do i need to use a macro.(not
sure how those work).. Please help! Thanks!
Click to expand...

The combo boxes used for filtering should - MUST! - be "Unbound", that is,
they should have nothing in their Control Source field. That seems to be your
problem.

To filter one combo on the basis of the contents of another combo, use a Query
as the row source for the second combo, using the first combo as a criterion.
If you could post a bit of information about your tables and the nature of the
filtering someone should be able to help set this up.
 
John W. Vinson said:
The combo boxes used for filtering should - MUST! - be "Unbound", that is,
they should have nothing in their Control Source field. That seems to be your
problem.

To filter one combo on the basis of the contents of another combo, use a Query
as the row source for the second combo, using the first combo as a criterion.
If you could post a bit of information about your tables and the nature of the
filtering someone should be able to help set this up.
Click to expand...

Where do i enter the criterion? Hopefully i can explain this better.... We
have a database of all the motors we can sell. The point of the databse is
for our sale reps to be able to go in adn click specific specs of a motor and
be able to come up with a list of motors they can quote(different brands &
prices). We only want them to be able to pick from a list of Phase, HP,
RPM... so they can get the correct information in there. (we converted
decimals to fractions) What i would like to do is be able to have drop down
list that have the information that they can choose from. Right now i have
phase as a combo box, unbound. I created the combo box with a wizard. Clicked
on "i want the combo box to look up the values in a table or query." Next
choose the Small Motors table (which has a column for each motor spec
matching with the part number). THen took Phase and put in the second column.
Last i sorted Phase in ascending order. When i go into form view, in the
bottom of my split form (where the table is) the phase column comes up empty.
When i go to the drop down list click on 1 it fills 1 all the way down the
column, click on 3 does the same thing but doesn't change the part number or
any other information. What am i doing wrong???
 
Back
Top