Combo box

[Guest]

Hi -

Thanks for your assistance. I have a field in a table called Vendor which
is formatted as Text. I have a combo box on a form which looks up info from
my vendor table, and then puts the selected vendor name in the Main table.
Works great, except when I create a report I get the id number of the vendor
instead of the vendor name. Help! Thanks

 

[tina]

sounds like the Vendor field in your Main table is a Lookup field. i'm
guessing that your Vendor table has a numeric primary key field, and a Text
field for the VendorName. if that's correct, then what's happening is that
the VendorID is being saved into the Main table, and the Lookup field is
disguising it - when you look at the table, you see the VendorName, even
though the saved value is the VendorID.

Lookup fields cause all kinds of problems; i strongly urge you to remove the
Lookup from your Vendor field in the Main table. see the following link for
more on Lookup field problems:
http://www.mvps.org/access/lookupfields.htm

base your report on a query. in the query, link the Vendor table to the Main
table, and add the VendorName field to the query's output. in the report,
you can display the VendorName instead of the VendorID.

hth

 

[Lee Li]

hi, it might becos yr combo box on the form is pointing to ID number field.
Right click the combo box and select the properties and change the source
column to Vendor.