Table Created Cant link new form

  • Thread starter Thread starter MaryP2219
  • Start date Start date
M

MaryP2219

Somehow my form got corrupted and I can't open it. I recreated it but can't
get it hooked up to the existing table. Any suggestions?
Thanks
 
Have you tried compacting and repairing

Alternatively, start a new database, import the table and create a new form
 
I'm not sure how to do that but I'll check and give it a try. Thanks for the
suggestion.
 
Somehow my form got corrupted and I can't open it. I recreated it but can't
get it hooked up to the existing table. Any suggestions?
Thanks
Click to expand...

First step: MAKE A BACKUP OF YOUR DATABASE. Corruption can spread, and one
corrupt form can cause trouble elsewhere! You may need the backup in case some
of the efforts to fix it cause MORE trouble.

Then delete the damaged form, and select Tools... Database Utilities...
Compact and Repair database (that's in 2003 and earlier, I believe it's in a
maintenance menu under the Office button in 2007).

If this succeeds, open your recreated form in design view; view its
Properties; and look at the "Recordsource" property, first one under the Data
tab. This should be either the name of the table or of a query based on the
table.
 
Back
Top