How do I troubleshoot forms in Access?

[DancingTor]

I have built a form in MS Access 2007 using design view but when I go to open
the form in data-entry or layout views, none of the fields show up. I cannot
seem to correct this and do not know where the troubleshooting option for
forms is.

 

[Arvin Meyer [MVP]]

You've probably based the form on a query that isn't updateable. To fix it,
you'll need to correct the query.

 

[Dirk Goldgar]

I have built a form in MS Access 2007 using design view but when I go to
open
the form in data-entry or layout views, none of the fields show up. I
cannot
seem to correct this and do not know where the troubleshooting option for
forms is.

Is the detail section of the form totally blank? Usually this means that
your form's RecordSource is returning no records, and no new records can be
added because either (a) the form's AllowAdditions property is set to No, or
(b) the form's RecordSource is a query that is not updatable, or (c) the
whole database is in read-only mode.

 

[Jeff Boyce]

If the form has no data "feeding" it, you might see something like this.

What's the data source?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[mary zak]

I'm actually having the same problem and no one knows how to fix it. My form
isn't based on a query, but on 3 separate tables. The details section is not
blank and as far as I know I am not in Read Only mode. Did you figure out the
problem?

 

[Linq Adams via AccessMonster.com]

If you form is based on 3 separate tables it ***has to have a query*** as its
Record Source, even if it's an Access generated query. The answers above
apply to you as well, Mary.