Text box bound to combo box

[Tari]

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!

[June7]

Is this combobox unbound? Is purpose of form to enter payments? Show form's RecordSource SQL statement.

The combobox has only 2 columns (ID and Name). There is no column 3, 4 or so on to reference.

Multiple similar named fields (Payment1, Payment2) indicates data is not normalized. Company is limited to 2 payments?

[Tari]

Oh I see.. I misunderstood how this works. I though that it was refering to column in my table, not the combobox. got it now

Here is what I'm trying to do:

I have a table with company name and a bunch of columns for payments. the form is ment to keep track of actual payments versus what it should've been by contract.

What I want to do is that you have a drop down box that gives you all company names to select from and once you selected a company the other fields display the information related to that company.

attached a simplified version of what i wanna do .. table and form.
so if you select company A in the drop down i want date 1 to be shown as 01/01/12 and amount1 $1. if you select company B it has to change to date 03/03/12 and $3

Hope that made any sense

[June7]

What is a 'bunch' of columns (how many, you show 2 payment columns)?

Several ways to do this. You can include the payment columns in the combobox (hidden by setting 0 width) then refer to the appropriate column in the textbox ControlSource.

Or check this tutorial http://datapigtechnologies.com/flash...tomfilter.html

Or use DLookup function. Domain aggregate functions can be slow. Use on forms and reports only if absolutely have to.

[Tari]

Or check this tutorial http://datapigtechnologies.com/flash...tomfilter.html

That tutorial is awesome and helped me tons. Thank you!