Constraining combo boxes

[matey56]

Hello,
I have 2 unbound combo boxes to select records. The first box is ID Number and the second box is Material. Once options are selected from both fields a record is displayed. The Material field has ten options. The ID Number field can be unlimited. Not every ID number in the table will have every Material type. What I would like is when the user selects an ID Number, the Material field then only displays options that are actually in the table. Not the entire list of 10. Does that make sense?

How do I do this?

[pbaldy]

Does this seem relevant?

https://www.baldyweb.com/CascadingCombo.htm

[A S MANN]

Prepare a query and filter it by Forms![FormName]![ID Number]
Use this query as record source of Material field of form. Select after update as Requery
so when a ID is selected the query data get modified , refreshed and lookup in Material changes.