Help form Blank

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

I currently have a few forms all set to the switchboard. They all worked
yesterday and today when they pull them up they are blank. The form still
exists and I can go in design view. Any ideas why they would be blank? It
is only the 2 forms that link to the same table. The other forms to the
other tables are working.
Thanks
 
I currently have a few forms all set to the switchboard. They all worked
yesterday and today when they pull them up they are blank. The form still
exists and I can go in design view. Any ideas why they would be blank? It
is only the 2 forms that link to the same table. The other forms to the
other tables are working.
Thanks
Click to expand...

The "blank form" symptom suggests that two things are true:

1. The Form's Recordsource query returns no records, so you don't see any
existing data.
2. The Recordsource is not updateable, so you don't see the new blank record
either.

If this has happened suddenly, it's very likely that your database has become
corrupted. See
http://www.granite.ab.ca/access/corruptmdbs.htm
for some symptoms and cures.

Or you may have changed something in the query upon which the form is based,
or the table itself has become read-only somehow. Can you open the table as a
datasheet, and does it have the *> "new record" line at the bottom?
 
Back
Top