Access Forms

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

Allen Browne

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

Dirk Goldgar

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?

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?".
 

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