Categories

[Mik3]

Hi,
I have a database with tools, divided into categories.
In a form I need to hae 2 combo boxes - one in which the user chooses the category, and the second in which he chooses from the tools in that category.
How can I make the tools in the tool combo box change, depending on what the chosen category is?
Thanks,

Mike

 

[Mile-O]

Have a look at my attachment here.

 

[Mik3]

Thanks for your reply.
I tried to do it like your example, however I couldn't make it work (probabbly coz I'm still a bit new to access).
I managed to do it using a DLookUp from a query, and it did work, to a certain point. It only shows 1 result (the first) in the "Tools" combo box.
Any ideas how I can fix this problem?

 

[Mik3]

can the problem be the DLookUp...does it only return a single value?
please help me - my boss would want me to change the whole layout of my database if I don't make this thing work

thanks,

mike

 

[Rich]

Search here for cascading combo boxes

 

[Mile-O]

can the problem be the DLookUp...does it only return a single value?

Yes, it only returns one value. Functions generally do that!

What was it about my example that you couldn't get to work?

 

[Mik3]

The DLookUp was the problem in fact, and I solved it using the criteria in a query.
I just couldn't apply your example to my database. I mean..I didn't know how to do it.