Number ID instead of Name showing when Access/Excel Connect

[jurbin]

Hello, I am currently having an issue with my Access Database that I tried to connect with Excel. For some reason when I try to connect my Excel Table to my Database, the infomation updates in excel, but for some reason in columns where I used a combo box to select from a table in access, it lists the ID number instead of a persons name. I have tried to change the formula, but it seems to always just export/update the ID number instead of the name that shows in the table. When I actually click 'EXPORT' the name exports, but if I try to link my excel doc to an access DB, only the ID number exports instead of the name. Any help?>

[trevor40]

check the combo box column count and bound column. If the bound column is set to 1 and the combo box field widths are set to say 0cm;5cm then you only see the second column data and not the linked column which is probably the Id field.

[jurbin]

Here is a screenshot of my combo box. Do you know what I would need to do in order to change the output?

[orange]

Change the bound column to 2 and try it.

[jurbin]

Change the bound column to 2 and try it.

Thanks Orange, but I did try that and all that did was actually change the item type to the number ON my database now as well as the connected excel sheet. Previously it looked good in the database but not when moved into the sheet.

[orange]

Have you found a solution?
I believe combo box field numbering is 0 based (start with 0 not 1) so I don't see why your origiinal set up was passing the ID and not the Name.

[June7]

You are building Lookup in table. Advise against that. http://access.mvps.org/access/lookupfields.htm

What is the query that Excel is linking to? Does it include Employees_tbl so the related name fields are available?

According to your other thread you are not able to see queries from Excel therefore you must be linking to table that is saving the value from combobox. In which case, the actual value is the ID and that is what the Excel link will retrieve.

[orange]

Good point June, I didn't pick up on the table. The OP mentioned combobox.