Hello,

Trying to filter data from a subform to show only line items that reference data selected in a combo box elswhere in the form?

In other words, I have a combo box of employees. When I select an employee, I want the info in the subform to only shoe data for that employee. Currently the subform shows data for all employees.

Can anyone help with this? Though I would try here first.

Thanks!

Try the following code:

Form_subFormName.RecordSource = ("Select * from TABLENAME where FIELDNAME = '" & Me.cboCONTROLnAME & "'")

and then I usually requery the subform to be sure it refreshes after you set the recordsource.

Form_SUBFORMNAME.Requery

Hope that helps.

That works. Thanks Brian!