Code to pull in a fied from SQL server?

[pcride]

I migrated all my data to SQL and have a linked data connection (Table) to my access database. I have repointed all the form fields to the new linked table by using
=[dbo_Survey_Main]![Reviewer]

But now all I get is #Name? in every field. Do I not have the expression correct?

 

[pcride]

I just need to change the main control source then I change the form fields back. So now it works.

Thanks,

 

[pcride]

Actually I just thought of something...

Since this DB would be used on a network and I don't want each person to have to create an ODBC connection in order to use the DB.

I thought the command was [SELECT].Table Name blah blah..

I would need this in the form field to pull in the data from SQL