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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
If there are no records and the Record Source for the form is not
updateable, then that will happen.
 
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.
 
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/
 
Back
Top