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.
====
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box not displaying field from SQL backend 0
Combo box not displaying field from SQL backend 1
Dynamic Naming of Form Button 3
Combo box 0
combo box filter 1
SQL Server Backend is Read Only 7
Access 2007-Table not displaying the values from a combo box 2
Problem designing a form envolving many-to-many relationships 3

Top