Controling Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a data base with many data fields but there are three main fields
which is getting the best of me. The three fields are "Prop Type" which has
three choices (Steam, Diesel and Gas Turbine) no once I choice from one of
those three the next field is "Ship Class" which has about 15 choices now the
third field is "Ship Name" and has about 200 choices. What I want to do is to
filter the Ships names down based on the Prop Type field. So if I choice
"Turbine" then when I pull down the Ships name it will only show the Ships
names which are Turbine driven. Any ideas would be great. Thanks
 
There are a couple ways to do it:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209576

http://office.microsoft.com/en-us/assistance/HP011538611033.aspx

--
Troy

Troy Munford
Development Operations Manager
FMS, Inc.
www.fmsinc.com


I have a data base with many data fields but there are three main fields
which is getting the best of me. The three fields are "Prop Type" which has
three choices (Steam, Diesel and Gas Turbine) no once I choice from one of
those three the next field is "Ship Class" which has about 15 choices now
the
third field is "Ship Name" and has about 200 choices. What I want to do is
to
filter the Ships names down based on the Prop Type field. So if I choice
"Turbine" then when I pull down the Ships name it will only show the Ships
names which are Turbine driven. Any ideas would be great. Thanks
 
Thanks for your help Troy.

I learned a lot from those articles however I could get them to work in a
test Database but it would not work in my Database. The problem, as I believe
it is, in the test Database had a relationship within the two Tables and in
the Database I had really doesn't have anytihng between the two or three
Tables that you could create a relationship on. I had one Table with all
Fields in it, then another with three fields from the main Table and then two
other Tables that I used for Combo box options. Nothing really I could create
a relationship though. I don't know what to do now but I just changed the
Database around some and I will just have to do the extra work when entering
a new line.

But again thanks for your help.

Rob
 
Back
Top