[AccessD] A2K: Something new

Dear Group,

You think you've seen it all, when all of a sudden...

I've taken over development and support of a domestic violence shelter statistics program. In my efforts to re-factor (how's that for an Extreme Programming term?) some of the data entry forms I've run into something odd.

One of the main data entry forms (key field ChildID) has a subform which contains a Tab object. Each of the tabs on this subform contains a sub-subform. While getting familiar with the workings of the program I noticed that one of the sub-subforms did not have the proper linking fields set up.

The subform's linking field is that same ChildID...but the RecordSource table for the subform is NOT keyed! The sub-subform in question also has only ChildID as the linking field...but the key field for the sub-subform's table is FreeFormID. ChildID is a foreign key in that table.

The behavior I'm seeing is this: when I go to check the linking fields in the subform I noticed that the VB window's title bar shows the following:

Microsoft Visual Basic - STATISTICS [running]

After a moment I see the Subform Field Linker dialog box. While the dialog box is on-screen the title bar of the VB window shows [running]. When I close the dialog box the VB window flashes and [running] disappears from the title bar.

But when I go to check the linking fields for the sub-subform in question, [running] appears once again in the VB title bar, but then I see a Microsoft Access dialog box with the following message and OK button:

Object variable or With block variable not set

...as if the application was trying to start itself! I can't get at the Subform Field Linker dialog box at all. When I click OK on the dialog box the VB window flashes and [running] disappears from the title bar.

So I tried deleting the sub-subform and placing it on the tab page again. When I've finished using the subform tool to place the object on the tab page, I get another dialog box labeled "StatsTracker" (the name of the application):

Your code contains a syntax error, or a Stats Tracker function you need isn't available.
If the syntax is correct, check the Control Wizards subkey or the Libraries key in the StatsTracker section of the Windows Registry to verify that the entries you need are listed and available.

I click OK and I see the subform object on the tab page. I can assign the Source Object property, but when I go to Link Master Fields I get the "Object variable or With block variable not set" message.

Can any of you figure out what's happening to me here? Thank you.
 
Regards,
 
Steve Erbach
Scientific Marketing
Neenah, WI
920-969-0504

Message created with Bloomba
 
Disclaimer: No tree was killed in the transmission of this message. However, several coulombs of electrons were temporarily inconvenienced.