Subform not opening

[jsic1210]

Hello,

I'm trying to open a form with a subform from a separate form. I've never had any issue before, but all of the sudden, the subform doesn't seem to open immediately. I get the error

Method 'Form' of object '_SubForm' failed.

After that, it opens (subform and all), but some calculated text fields just say "#Name?#"
The only thing I did today was add a command button to that subform.

When I try opening the form (or subform) from the navigation pane, I get

The expression On Current you entered as the event property setting produced the following error:
A problem occurred while Contracts was communicating with the OLE server or ActiveX Control

When I step through the code, it doesn't reach the On Current event.

 

[spikepl]

What are the names of your form and subform?
What happens if you press Code Window > Debug>Compile

 

[jsic1210]

Form: frmContractForm
Sub: frmContractSub

Compiling didn't show any errors.

When I deleted all the On Current code for the subform, they both opened with no error messages from the Navigation Pane. But there are calculated fields just producing #Name? errors. I even added a new calculated field with the simple Control Source: "=[renewaldate]" (one of the bound fields from the underlying table). That produced the same #Name? error. The renewaldate field shows a legitimate date, though.

 

[spikepl]

OK.. when no clue, then the first thing to do is to claim "corruption". So make a new db, into that db import all the objects from old db, compact& repair and see if that helps.

 

[spikepl]

Hold on a sec .. what object _SubForm do you have? What is the name of your subform container then?

 

[jsic1210]

I'm not sure what you mean by object_SubForm and subform container.

When I moved to a new database, everything worked fine. Should I assume my db is corrupt and just work from the new one?