Value of combo box: row number instead of string

  • Thread starter Thread starter Jasper de Bruin
  • Start date Start date
J

Jasper de Bruin

I'm using a drop down box to create a report based on the
selected customer name. The names are looked up from a
table and this works fine.

However, if I select the third name from the list (for
instance "smith"), the number 3 is submitted to generate
the report instead of the value "smith".

How can this be solved?
 
Jasper,
All you need to do is to change the Bound Column value. If you look at the Row Source property of the combo box (in design view) you'll see the order of your columns (fields). Simply update the Bound Column to match the order of your Name field.
 
-----Original Message-----
Jasper,
All you need to do is to change the Bound Column value.
Click to expand...
If you look at the Row Source property of the combo box
(in design view) you'll see the order of your columns
(fields). Simply update the Bound Column to match the
order of your Name field.
.
Click to expand...

It worked!
Thanks a lot!
 
Back
Top