Forms not displaying in 'Form View' with ODBC connection to SQL Table 1

[daveinchicago]

If created an ODBC connection to some SQL Tables and created forms from the fields on these tables. When I select form view or even layout view the form appears totally blank.

These forms worked when they were connected to local tables.

I do see the tables in the 'tables' section in Access 2010.

thanks for your help!!

 

[PHV]

Are the tables populated ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[daveinchicago]

no, not all of them.

 

[dhookom]

Are your forms in Data Entry mode?
Do the tables all have primary keys?
Are the record sources just tables or queries?
- If they are queries, can you share the SQL views?


Duane
Hook'D on Access
MS Access MVP

 

[daveinchicago]

Thanks! They just needed data...