blank form

  • Thread starter Thread starter NAS
  • Start date Start date
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
 
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
Click to expand...


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?"
 
AllowAdditions was set to no, and changing it to yes fixed the issue. Thank
you very much for your help.
 
Back
Top