generate selection

[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

 

[Dirk Goldgar]

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

This page shows two ways to do it:

http://www.mvps.org/access/forms/frm0028.htm
Forms: Limit content of combo/list boxes

 

[NevilleT]

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.