combo and list box link

[stuck]

I would like to add a list box to my form to display items based on a category chosen in the Category combo box and my train of thought just derailed, so I would greatly appreciate some help. The form is for entering material ( tbl Materials). The combo box is labelled Category (tbl AddCategory). I've tried a couple of suggestions from the posts but have had only limited success.
Thanks in advance.

 

[JimHorton]

Let's say your combo box is called cboCat. This listbox is called lstMat
In the AfterUpdate of cboCat, put
Me.lstMat.RowSource = &quot;SELECT * FROM tblMaterials where category = '&quot; & Me.cboCat & &quot;'&quot; '<--assuming Category is text

the Select * is here just for brevity, you may want to just list a few fields, but obvioulsy make the Columncount match the # of columns.
--Jim