Access form combobox help

I know there are special forums for this, but i've generally found the folks on here to be very knowledgable about this :o)

Anyways, i have a table:

Price List
----------

Fields
------
Material Price Per Company


Now i have a form called Order Form with a combo box. From this ComboBox, you select a company. Upon selecting a company, i want to filter the data from the table, and have another combobox filled with a list of all materials from that company.

So i reckon i would populate the Combo box, with unique Company entries from the Price List table.

Populate the other ComboBox with the entire table of Materials. But have a query set up that will only show materials from the supplier choosen in the Company ComboBox.

I've tried everything i can think of, but i can't get the materials to show up, based on the selection from the Company ComboBox. I'm using 2003 access version. Any help is very much appreciated :o)

I'm assuming you're using VB to do this?

As soon as you change the Company combo box do you run an sql query agains the materials table in the database?

If so, just clear the current items in the Materials combo box and build it back up by traversing the recordset and adding new items to the combo box.

Nope, i'm just using access 2003. I'm not sure if i have VB on this computer, or whether it's integrated into the access package i have. I'm doing everything from the confines of menus and the expression builder.

VB is integrated in Access and i have absoluty no idea how to do what you want via the menus, i put vb code under everything.

Ok, thanks. I know a little bit of VB. Thanks again guys!