Microsoft Access List box value based on combobox value using rowsource

[Clete]

I have a combox that displays a file no named cmbInq. The file number is column (0) 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... below its the part that says equals cmbInq

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

 

[GinaWhipp]

Hmm, change the last part to...

cmbInq.Column(0)

 

[Clete]

I tried that as well and it doesn't work

 

[GinaWhipp]

Hmm, get rid of the DISTINCTROW.