Combo box not displaying field from SQL backend

  • Thread starter Thread starter amywolfie
  • Start date Start date
A

amywolfie

I am having a strange problem with a combo box in Access 2007:

My backend tables are SQL Server 2005, linked. There is one,
Departments, which contains a Primary Key and a Key Descriptor field
called Dept Name.

When I try to set up a combo box using both of these fields on a form,
I can see the PK just fine, but the Dept Name field does not appear as
a field to be selected.

I've tried designing queries to base the combo on -- data displays
fine in query results, but again, the field does NOT appear as an
option to be selected by the combo box.

Our SQL DBA has checked the backend and there doesn't seem to be
anything unusual there.

Has anyone else experienced this issue?

Thanks!
Amy
(e-mail address removed)

=====
 
amywolfie said:
I am having a strange problem with a combo box in Access 2007:

My backend tables are SQL Server 2005, linked. There is one,
Departments, which contains a Primary Key and a Key Descriptor field
called Dept Name.

When I try to set up a combo box using both of these fields on a form,
I can see the PK just fine, but the Dept Name field does not appear as
a field to be selected.

I've tried designing queries to base the combo on -- data displays
fine in query results, but again, the field does NOT appear as an
option to be selected by the combo box.

Our SQL DBA has checked the backend and there doesn't seem to be
anything unusual there.

Has anyone else experienced this issue?

Thanks!
Amy
(e-mail address removed)

=====
Click to expand...
 
Back
Top