Combo filters combo

  • Thread starter Thread starter Al Camp
  • Start date Start date
A

Al Camp

An often asked question on the "Forms" associated NGs is...

"How do I coordinate combo boxes?" (combobox2 is "filtered" by the
contents of combobox1)

This can be bit of a chore to explain and "fingerbone" into a post, and a
bit daunting for newbies to understand.

Can someone direct me to a good downloadable .mdb file that just deals
with this combobox coordination problem, so I can direct folks to it??

I checked out Stephen Leban's site, and the Access MVP site, but didn't
find an sample file that I could refer folks to... one that would show them
how it's done in an example form. I did find several methods on the web
that used "Code Only" to handle the problem, but that wouldn't be suitable
for new Access users.

I built an example form myself, but, I don't have a web/ftp site, and I
really don't like to "exchange" email addresses via NG posts, and I know
"attachments" are frowned upon in the NGs.

Thanks for any help...
 
following, this task is one that generally does, and should require some
code.

Further, as matter of course, I generally avoided using combo's on combo's.
This is just my personal preference, and I don't like them. Often, a MUCH
better UI can built using a form. For example, if I need to select a
company, and then select a bunch of past invoices *for* that company, then
often users will resort to using two combo's. I use the following approach:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm


However, there is number of examples of using combos on combos:

There is probably lots more, but I found following in less then 5 minutes of
time:

Both of the following have a combo on combo example:

ACC2000: Microsoft Access 2000 Sample Forms Database Available in Download
Center
http://support.microsoft.com/?id=233324

ACC97: Microsoft Access 97 Sample Forms Available in Download Center
http://support.microsoft.com/?id=175066


Here is a step by step example:
ACC2000: How to Create Synchronized Combo Boxes
http://support.microsoft.com/?id=209576

And, of course the mvp web has:
http://www.mvps.org/access/forms/frm0028.htm
 
Al,
Thanks for the links. I had completely forgotten about the A97 Sample
databases (97Solutions) from Microsoft. I had a copy of it on my drive...
and hadn't used in years. The Frmsmp97.mdb looks to be very much like my
old 97Solutions.mdb. Just what I was looking for... meat and potatoes!
Just a simple form with 2 synched combos.

I should have used "combo synchronize" in my search.

In my search for "microsoft access combo filter", I even visited your
site... before I got your post! I see what you're doing with list boxes,
and have used that same system in several of my recent designs, but... in
this case, I was really looking for a very rudimentary combo synching
"downloadable" sample form for "new" Access users. I usually try to
"explain" synching in my post, but if new users still have problems, I can
refer them to Frmsmp97.mdb.
I also found the MVP site code, but again, I think new users would have
trouble understanding the code... and translating it to their specific
needs..
The sample forms Frmsmp97.mdb are just the ticket.

Thanks for all your help,

Al Campagna
Candia Computer Consulting
Candia, NH
 
Without question, a simple stand alone combo on combo box example would
still not be bad.

As mentioned, there are number examples, but a nice "single" example as you
were looking for is still a good idea. The reason why I am so receptive to
your request is that you also hinted that it would good "handy" reference
for other posters, and in that light you are more then just looking for
answer, but a answer to share with people! That kind of attitude is what
really makes these newsgroups work! Good for you!

I think those examples are ok...but I keep my eyes open for any other single
examples.
 
Back
Top