I'm doing something wrong and I can't see what it is..
I have a simple table that is supposed to track payment $ & dates for companies.
so i have a table with a bunch of columns (company, payment 1, payment 1 date, payment 2, payment 2 date..).
on the form I have a combo box:
SELECT [Payments].[ID], [Payments].[Company Name] FROM Payments ORDER BY [Company Name];
then I set my textbox' row source to: =combo7.column(x)
0 = 1st column in table
1 = 2nd column in table
only 0 and 1 works. If I try 3, 4 and so on it does not pull the information. What am I doing wrong?
the goal of this is that you select the company name from your combo box and the associated payment information is displayed or can be entered.
thanks for the help!