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);
Code:
Code: