I see controls in design view but not form view. Why?

[Guest]

I am creating a new database that currently has tables set up but no records
(they will be added by the end-users). I created a form in design view, but
none of the fields I added are visible in form view. Visible property is set
to Yes. Header contents and background color are fine. Ideas?

 

[Wayne Morgan]

If there are no records and the Record Source for the form is not
updateable, then that will happen.

 

[Guest]

Thanks! That got me part way down the right path. Now I am stuck because
Access is telling me the form cannot link to an action query, only select
queries.

 

[Wayne Morgan]

Correct. An "action query" does some work, such as Update records in a
table, Delete records from a table, etc. A Select query retrieves records
from a table for display.

An "updateable" query is a Select query that will allow you to edit the
records retrieved by the query (i.e. you can make updates to the records). A
query can be not updateable due to the way tables are joined or by the
fields being displayed. For more information, see the following links:

http://support.microsoft.com/kb/209571/en-us
http://support.microsoft.com/kb/328828/