Drop down boxes

[Guest]

How do I link two drop down boxes. Let's say I have a General Category drop
down box and I have a Specific Problem Drop down box Now whatever You choose
from the General Category I want only certain ones to show up in the specific
problem drop down. For instance, Blinds for the general and I want like need
new ones all things similar to blinds not computer stuff like fuzzy picture
or anything Please I have been stuck on this

 

[Randy Harris]

How do I link two drop down boxes. Let's say I have a General Category drop
down box and I have a Specific Problem Drop down box Now whatever You choose
from the General Category I want only certain ones to show up in the specific
problem drop down. For instance, Blinds for the general and I want like need
new ones all things similar to blinds not computer stuff like fuzzy picture
or anything Please I have been stuck on this

What is wrong with the explanation Fred G gave you when you asked the same
question here a couple days ago?

 

[Guest]

Well that's funny because this is the first time i've been on here.

 

[RuralGuy]

Well that's funny because this is the first time i've been on here.

"Randy Harris" wrote:

In that case here's what FredG said:
___________________________________________________________
Leave the rowsource of the 2nd combo box blank.
Code the AfterUpdate event of the 1st combo box to fill the rowsource
of the 2nd. Something like this:

Combo2.Rowsource = "Select Instructors.InstructorID,
Instructors.InstructorName from Instructors Where Instructors.ClassID
= " & Me!ComboName & ";"

Change the table and field names as needed.
The above assumes ClassID is a Number datatype and the Combo1 bound
column is Number also.

The above will list only instructors who teach the same class.

Fred
______________________________________________________________

HTH

 

[Guest]

Well Thanks For forwarding me this information but I think that you all are
rude if you dont know me and don't know if i've been on here then you
shouldn't tell me what whoever Fred said

 

[RuralGuy]

Well Thanks For forwarding me this information but I think that you
all are rude if you dont know me and don't know if i've been on here
then you shouldn't tell me what whoever Fred said

Hi Veronica,

It was an honest mistake. There was an almost identical post yesterday
from veronica (with a small v).

Subject: How do I link two drop down boxes?

All I did was just copy Fred's response and post it to you after it was
obvious it was a different veronica.

These groups are all searchable by google. Even though it is enjoyable
helping people in these groups, your particular question is asked
practically every day. That means all of those people have not gearched
google yet and just leap out with the post.

I hope you can now better understand where Randy and Fred were coming
from. You need to give us a little break once in a while too.

HTH

 

[RuralGuy]

Veronica,

Here's a good resource to begin with in case you think I made everything
up.

Netiquette:
http://www.mvps.org/access/netiquette.htm

There is a ton of information on the mvps web site and the Netiquette
article is a great place to start.

I also noticed you milti-posted. Oops!

HTH

 

[Randy Harris]

Well Thanks For forwarding me this information but I think that you all are
rude if you dont know me and don't know if i've been on here then you
shouldn't tell me what whoever Fred said

Two different Veronicas, asking the same question, from the same posting
host on successive days? I doubt it.