Access Help
Author
Discussion

Onz

Original Poster:

507 posts

237 months

Monday 6th August 2007
quotequote all
Probably a laughably easy thing to do for anyone that knows what they're doing but I need some help!

I'll use Mobile Phone Brands and Individual handsets as an example here.

Assume I have an order form set up in access and I want to add which Mobile Phone Brands and Phones the order is for.

I want to be able to select the Mobile Phone Brand from a drop down box as a LookUp (I can do this bit smile ) but then I want the next drop down box to only display individual handsets from the previously selected manufacturer, not all handsets.

What is the best way of achieving what I am after?

Thanks for any help smile

splashout1

64 posts

272 months

Monday 6th August 2007
quotequote all
What I think you want to do is link the second box to a query that looks up the handsets from that manufacturer.

Create a query and use the first drop down box as a criteria for the manufacturer. If you right click on the criteria section in the design view of the query and select build, you can then select open forms and your first lookup box.

If you open the form and select a manufacturer then run the query you should now get all handsets from that manufacturer.

Then create a second drop down box who's data source is the newly created query.

You should be able to work this out if your table structure is good and make it work. If not I would need to know your table structure to aid you further.

Hope that makes sense

Oh and an after thought you may need to set up a requerry event after update of the first lookup box, if you intend to change this selection. This will in effect rerun the querry if the first box is changed so the second is always upto date.

Edited by splashout1 on Monday 6th August 15:16