Access Forms

  • Thread starter Thread starter wingweaver
  • Start date Start date
W

wingweaver

I created a form in MS Access; however, nothing shows
except the title while in form view. What could be the
reason for this?
 
The form shows nothing at all in the Detail secction if both:
a) there are no records to display, and
b) no new records can be added.

(a) happens in the table or query is empty, or if the form is filtered or
opened with a WhereCondition that returns nothing.

(b) happens if it is based on a read-only query, the form's AllowAdditions
property is set to No, the database is read-only, or there are no
permissions for appending records.
 
wingweaver said:
I created a form in MS Access; however, nothing shows
except the title while in form view. What could be the
reason for this?
Click to expand...

That usually means that the form's recordsource query or table returns
no records, and no records can be added because either the form's
AllowAdditions property is set to No, or the form is based on a
nonupdatable query. You can find out if the latter condition is true by
opening the query itself in datasheet view and seeing if you can modify
or add any records.

For reasons why your query may not be updatable, see the help topic,
"When can I update data from a query?".
 
Back
Top