Excel to Access link issues

[xPaul]

Hi all,

I am having trouble with what I believe is bound columns. I have followed the tutorial listed here for 'Cascading Combo Boxes' - https://www.fmsinc.com/MicrosoftAccess/Forms/combo-boxes/cascading.html.

Within the database itself, the tutorial given works a dream and causes me no issues whatsoever. I like the way it functions and it functions well. I have created and uploaded a sample database with a form for ease and to show how it works. At this time please also take a look at how tblListofCars is formatted - Makes and Models actually show as text.

My issue is when I try to link Excel to access. Again, I have included an Excel Spreadsheet for ease.

If you open Excel (2010) and open the data tab:

1. Press 'From Access'
2. Browse to the 'Access Programmers Test.accdb' database
3. In the new window select the table tblListofCars
4. Press 'OK'

You can see that instead of returning the proper CarMake and CarModel text items like 'Nissan' or 'Ford' it returns their numerical values. Is there anything that I change to get a way around this?

Thank you in advance and I appreciate your help as always.

Note - the uploaded example can be used to see how cascading combo boxes work for those maybe having difficulty.