How do I troubleshoot forms in Access?

  • Thread starter Thread starter DancingTor
  • Start date Start date
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.
 
You've probably based the form on a query that isn't updateable. To fix it,
you'll need to correct the query.
 
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.
Click to expand...


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.
 
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
 
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?
 
Back
Top