Hi everyone this has been doing my head in for 4 hours now, right the situation is that i have a materials table, parts table and a category table each table has a field called category. I have created a form Materials, the field category on the materials form should be a dropdown this gets its values from the categories table.

Then once we have done this we have another dropdown box that allows us to select the parts from within that category, this should be done by getting the value from the category dropdown box and then matching and displaying another dropdown box i.e the parts dropdown box, filtered with the parts relivant to that category.

If anyone can help i would be much appriciated

Thanks

Steve

Welcome to Utter Access!

I think what you are needing is called cascading combo boxes.

Check this out from the code archive here at Utter Access:

Cascade Combo - with two tables