blank form

N

NAS

I have a form that is blank when I open it in form view but in design view
everything is there. I am using Access 2003 on Windows XP. I'm pretty new to
databases so if any other info is needed please let me know. Thanks
 
D

Dirk Goldgar

NAS said:
I have a form that is blank when I open it in form view but in design view
everything is there. I am using Access 2003 on Windows XP. I'm pretty new
to
databases so if any other info is needed please let me know. Thanks


This happens when the form's recordsource has no records to display (table
is empty or query returns no records) and the form or query is set up such
that no records can be added: the form's AllowAdditions property is set to
No or the recordsource query is not updatable.

Most often, the problem is that the recordsource query is not updatable.
You can test that by opening the query directly as a datasheet, and seeing
if you can edit or add records. If that is the problem, see the help topic,
"When can I update data from a query?"
 
N

NAS

AllowAdditions was set to no, and changing it to yes fixed the issue. Thank
you very much for your help.
 

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