combo boxes - linking

[Nikkinovice]

Hi

I put a post on yesterday, trying to get help and now can't even find my
original post! Someone did point me in the direction for some help, but am
now all tied in knots and really need help.

I have a sub form which should enable the user to select a supplier (combo
box) and then in the next combo box allow the user to select a list of
products from that individual supplier, however it is not working. I spent
12 hours trying to solve this yesterday and am about to give up and stick to
using an excel spreadsheet (which while I am a huge fan of excel, is not the
answer). Is there anywhere where databases can be emailed for other (more
expert) users can view them. I have built several databases before, but for
some reason, this one is really winding me up. I know the answer the this is
probably no, but can't blame a girl for trying. I have linked combo boxes
before and i know this is probably something really simple which i am missing.

If the chap who tried to help me yesterday, happens to see this - thanks for
trying to help!

 

[Wayne-I-M]

You can find all your post her
http://www.microsoft.com/office/com...ft.public.access.gettingstarted&lang=en&cr=US

For the combo box thing.

Create a combo box (cmb1)
Make sure that you include the primary field (that links to 2 sets of data -
use the relationship window fr this if you have not already done it) in the
combo - can be set to length = 0 if you don't want people to see it.

Create another combo (cmb2)
Create a query to give this combo it's data. - use the wizard if you have
problems.
In the query (again use the wizard) set the criteria of the one of the
columns to point t your 1st combo (cmb1)

Don't forget to refresh cmb2 with the afterupdate event of cmb1

good luck