Form problem

[Guest]

I have an invoice database, where customer info is entered on each invoice.
Customer names are selected from a drop-down list on the form and show up on
the invoice report when printed. The form appears to be working, but the
customer ID number is showing up on new invoices, instead of the customer
name that was selected from the list. If I go into the table and manually
enter the customer name, then it works. Any ideas on why this is happening.

 

[Wayne Morgan]

The combo box has more than one column. The Bound Column is the ID field,
this is normal. You need to include the table that has the customer's ID and
Name in the query feeding the report. It should be linked to the current
table on the ID field. You would then pick the Customer Name field from this
table for the report.