Microsoft Access List box results based on combobox value using rowsource

[cleteh]

I have a combox that displays a file no named cmbInq. The file number is column (1) which is the only value I show in my combox. I want to display the results of the select statement in the list box based on the value in column box. Im not sure how to code the part after the equal sign... its the part that says equals cmbInq(0)


SELECT DISTINCTROW [CheckPayments].[CheckNo], [CheckPayments].[Date], [CheckPayments].[Amount] FROM [CheckPayments]WHERE [CheckPayments].[FileNo]=cmbInq(0);