Control Source Question

  • Thread starter Thread starter Cobb
  • Start date Start date
C

Cobb

Hello-
I've created a drop-down box on an Access form. The Control Source for this
box is a field within a SQL Server 2000 table that I'm connected to. The
table has been linked, and I can click it and see my fields in the table
view. When I double-click the drop-down in the form design view, and click
the data tab, I do not see field that I need ("assigned"). I've updated the
tables several times using the Linked Table Manager, but still do not see
the field.

The "assigned" field contains my names that can be chosen from the
drop-down.

Any ideas?

Thanks,
Chris
 
Hello-
I've created a drop-down box on an Access form. The Control Source for this
box is a field within a SQL Server 2000 table that I'm connected to. The
table has been linked, and I can click it and see my fields in the table
view. When I double-click the drop-down in the form design view, and click
the data tab, I do not see field that I need ("assigned"). I've updated the
tables several times using the Linked Table Manager, but still do not see
the field.

The "assigned" field contains my names that can be chosen from the
drop-down.

Any ideas?

Thanks,
Chris
Click to expand...

Try opening the Form in design view, and view its properties. Select
the Record Source property (first on the Data tab) and click the ...
icon by it.

I suspect the [Assigned] field isn't in the query upon which the form
is based; just add it (if need be, joining the table containing it to
the query).
 
Brilliant!

That was the problem.

Thanks,
Chris




John Vinson said:
Hello-
I've created a drop-down box on an Access form. The Control Source for this
box is a field within a SQL Server 2000 table that I'm connected to. The
table has been linked, and I can click it and see my fields in the table
view. When I double-click the drop-down in the form design view, and click
the data tab, I do not see field that I need ("assigned"). I've updated the
tables several times using the Linked Table Manager, but still do not see
the field.

The "assigned" field contains my names that can be chosen from the
drop-down.

Any ideas?

Thanks,
Chris
Click to expand...

Try opening the Form in design view, and view its properties. Select
the Record Source property (first on the Data tab) and click the ...
icon by it.

I suspect the [Assigned] field isn't in the query upon which the form
is based; just add it (if need be, joining the table containing it to
the query).
Click to expand...
 
Back
Top