Combo box filtering contents of other combo box

[Richard]

Very urgent help required.

I am designing a Purchase Order database using Northwind as my template.

On the orders form, I am using a subform to enter order item details. I want
to filter the "supplierid" from a combo box, which then restricts the
"categoryid" of products, furthering restricting the "productsid". Ideally I
would like to place the "supplierid" on the main form, which would filter the
other combos similar to above.

I need to finish this project urgently, and having only a little VBA
experience, am really struggling. Any urgent help would be greatly
appreciated.

Regards,

Richard

 

[Rick B]

Do a search. Asked and answered almost every single day in these
newsgroups.

Look for "cascading combo".