How do I troubleshoot forms in Access?

D

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.
 
A

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.
 
D

Dirk Goldgar

DancingTor said:
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.
 
J

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
 
M

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top