By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Need help filtering records with combo boxes

P: n/a
I want to create a form that searches a table. The hard part is this,
I'd like to have the available records filtered based on combobox
selections. For example, if this were a vehicle database, I might want
to filter by AutomobileType, Year, Make, Model, Color. In this case it
would work like this:

First all of the records are available, that is, every kind of auto.
So I select from my AutomobileType combobox "2003". Now I only have
records available for autos made in 2003. I filter more by selecting
"Dodge". Now only Dodge vehicles made in 2003 are available.
Continuing with this process, I select "Caravan" and "Red". Now only
Red Dodge Caravans made in 2003 are available.

My actual application is a little different, but this paints my
situation exactly. How can I use comboboxes to filter a form in this
way? I'm familiar with VBA if that helps.

Thanks in advance.

- Luther
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
http://www.mvps.org/access/forms/frm0028.htm at "The Access Web" shows one
way of doing this.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Luther" <lc*****@yahoo.com> wrote in message
news:4a*************************@posting.google.co m...
I want to create a form that searches a table. The hard part is this,
I'd like to have the available records filtered based on combobox
selections. For example, if this were a vehicle database, I might want
to filter by AutomobileType, Year, Make, Model, Color. In this case it
would work like this:

First all of the records are available, that is, every kind of auto.
So I select from my AutomobileType combobox "2003". Now I only have
records available for autos made in 2003. I filter more by selecting
"Dodge". Now only Dodge vehicles made in 2003 are available.
Continuing with this process, I select "Caravan" and "Red". Now only
Red Dodge Caravans made in 2003 are available.

My actual application is a little different, but this paints my
situation exactly. How can I use comboboxes to filter a form in this
way? I'm familiar with VBA if that helps.

Thanks in advance.

- Luther

Nov 12 '05 #2

P: n/a
Hi Luther,

Scott Barker offers an example, using a movie database, in his Power Programming
series of books. I'd recommend buying a copy of his book and then take a look
at the sample database, which I believe is named chap08.mdb (I don't have a copy
handy at the moment). This filter by form sample is one of the few that I have
seen that includes "real-time" filtering as you described. Look for "Access
2002 Power Programming" (or whichever version you are using) at your favorite
bookstore. I think it would be a bit much to try to cover the "how-to" in a
newsgroup reply.

Tom
__________________________________

"Luther" <lc*****@yahoo.com> wrote in message
news:4a*************************@posting.google.co m...
I want to create a form that searches a table. The hard part is this,
I'd like to have the available records filtered based on combobox
selections. For example, if this were a vehicle database, I might want
to filter by AutomobileType, Year, Make, Model, Color. In this case it
would work like this:

First all of the records are available, that is, every kind of auto.
So I select from my AutomobileType combobox "2003". Now I only have
records available for autos made in 2003. I filter more by selecting
"Dodge". Now only Dodge vehicles made in 2003 are available.
Continuing with this process, I select "Caravan" and "Red". Now only
Red Dodge Caravans made in 2003 are available.

My actual application is a little different, but this paints my
situation exactly. How can I use comboboxes to filter a form in this
way? I'm familiar with VBA if that helps.

Thanks in advance.

- Luther
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.