Combo box not displaying field from SQL backend

A

amywolfie

I am using Access 2007 with a MS SQL Server 2005 backend (linked SQL
tables).

I am trying to set up a combo box with 2 fields from tblDepartments.
One field is the PK, the other is Dept Name. The PK is a GUID and
Dept Name is text -- both are coming in from a linked SQL table.

I am able to view the PK in the combo box Wizard, but the Dept Name
field is NOT visible. I've tried creating a query to base the combo
on, and same result.

Has anyone else experienced this issue?

Thanks.
====
 
Top