Using the CBO method of combo boxes

[Guest]

I used the CBO method to automatically populate the name of our accounts
based off the of account number we entered. While this works in the form the
account name does not transfer to the table. Our problem is all of our
reports pull data from the table based on the account name and not the
number. Is there some way to get the data to post from the form to the table
as would normally occur?

 

[Guest]

I used the CBO method to automatically populate the name of our accounts
based off the of account number we entered. While this works in the form the
account name does not transfer to the table. Our problem is all of our
reports pull data from the table based on the account name and not the
number. Is there some way to get the data to post from the form to the table
as would normally occur?

 

[Guest]

Sorry about the blank post!

You should not store the account name in the referencing table, only the
foreign key account number, which will be the ControlSource of the combo box
on the form, and this its value, although it shows the names. To store both
would constitute redundancy, which leaves the door open to update anomalies
as it would be possible to have the same account number and different account
names in separate rows, or vice versa.

The report should be based on a query which joins the table with the foreign
key account number (the referencing table), which is the table your report is
based on at present to judge by what you say, to the table with the primary
key account number and the account name (the referenced table). You can then
include the account name in a column in the query and bind a text box to this
column in the report. The join is made on the account number fields.

Ken Sheridan
Stafford, England