Question Exporting to Excel changes field value

[missangie]

Hi,

I'm relatively new to Access. I've created a database where we track product information and testing done on the products. I have the Product Code set up as a combo box with five other fields auto populating based on what is entered into the Product Code field. However, when I export the table or form to Excel, the Product Code changes to another number, which I think is an auto number but does not directly relate to the product entered (either one up or down from the product).
Any help would be greatly appreciated.

Thanks,

Angela

 

[boblarson]

Sounds like you are using lookups at table level, which is not good. (See here for more about that: http://www.mvps.org/access/lookupfields.htm)

So, you can use lookups at form level but what you want to export is really a query which has the lookup table included and select that text description as one of the fields to use instead of the ID field.

 

[PaulO]

You could perhaps export the data from a QUERY (based on the Table) rather than the TABLE itself??