generate selection

  • Thread starter Thread starter Kantor
  • Start date Start date
K

Kantor

Hello

I wonder if anyone in this forum can help me with the following. Noone else
has been able to give me an answer.
Here is my issue:
I want to generate a selection in a drop down list based on a selection I
have done from a previous drop down list.
Example: Let's say I run a company selling mobile phones.
In the subform (access) I don't want to have hundreds to pick from. First I
want to pick (drop down list) from the mobile vendor as: Nokia, Samsung etc.
Lets's say I pick Nokia. In the next drop down list I only want to view the
mobile types from Nokia (and not from all the others too).
I have tried to be creative, using macros etc. but with no luck.

Any answers?
Need help!
Best regards
Børge
Norway
 
Kantor said:
Hello

I wonder if anyone in this forum can help me with the following. Noone
else
has been able to give me an answer.
Here is my issue:
I want to generate a selection in a drop down list based on a selection I
have done from a previous drop down list.
Example: Let's say I run a company selling mobile phones.
In the subform (access) I don't want to have hundreds to pick from. First
I
want to pick (drop down list) from the mobile vendor as: Nokia, Samsung
etc.
Lets's say I pick Nokia. In the next drop down list I only want to view
the
mobile types from Nokia (and not from all the others too).
I have tried to be creative, using macros etc. but with no luck.

Any answers?
Need help!
Best regards
Børge
Norway
Click to expand...


This page shows two ways to do it:

http://www.mvps.org/access/forms/frm0028.htm
Forms: Limit content of combo/list boxes
 
Suggest you use a query that uses the first combo as a criteria. Something
like
SELECT tblModel.ModelNo, tblModel.ModelName, tblModel.Brand from tblModel
WHERE tblModel.Brand = Me.cmbBrand. Use the query builder to build it.

When you select the second combo, do a requery. Use the On Got Focus event
to add the requery.
 
Back
Top