Not able to select value from combo box.

[Robert Garnett]

I need help with a form that I am trying to select a value
from a combo box to populate that same field. The table
that needs to be updated with this value is an SQL table
that is ODBC linked through Access 2002. The values are
in a query based upon the linked odbc sql table. I am
using SQL Server 7.0 with Access.

Can someone please help me out?

 

[Rick Brandt]

I need help with a form that I am trying to select a value
from a combo box to populate that same field. The table
that needs to be updated with this value is an SQL table
that is ODBC linked through Access 2002. The values are
in a query based upon the linked odbc sql table. I am
using SQL Server 7.0 with Access.

Can someone please help me out?

"Not able" doesn't give us much to go on. What happens? Nothing? Do you get an
Error? Can you update that field directly in the link or is the problem only
when using the ComboBox?

 

[Art]

Are the edits enabled? You can't select an item in a combo box if they are.
Art