ComboBox results on form show as a number in report


J

jackmac

Hi all,

I have a form which has a ComboBox with supplier names. I created a table
just for the suppliers and the combo box is populated by this table. When I
try to run a report or query based on products, the supplier field doesn't
show names, only numbers! I'm guessing the numbers relate to item number
for the Supplier record in the table (is that right?) The difficulty I have
is that if I try to run a report based on a particular supplier it won't
work as it only sees numbers!

Anybody any idea how I can get the supplier nams to show and not numbers?

TIA

Jack
 
Ad

Advertisements

J

John W. Vinson

Hi all,

I have a form which has a ComboBox with supplier names. I created a table
just for the suppliers and the combo box is populated by this table. When I
try to run a report or query based on products, the supplier field doesn't
show names, only numbers! I'm guessing the numbers relate to item number
for the Supplier record in the table (is that right?) The difficulty I have
is that if I try to run a report based on a particular supplier it won't
work as it only sees numbers!

Anybody any idea how I can get the supplier nams to show and not numbers?

TIA

Jack

Base the Report on a Query joining your main table to the combo box's row
source. You are likely another victim of the Lookup Field misfeature, which
conceals the actual contents of your field behind a combo box; what's actually
stored in your table is a numeric ID, but what you SEE is a supplier name
looked up from another table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top