[AccessD] Re: A2K: Something new

Steve,

If you can send me the db, without data, I will look at
it and see what I can figure our from it.

Robert


P.S.  I tried to send this to your email:  serbach at new.rr.com
and go it returned

At 09:33 AM 1/22/2004 -0600, you wrote:
>Date: Thu, 22 Jan 2004 07:54:09 -0600
>From: "Steven W. Erbach" <serbach at new.rr.com>
>Subject: [AccessD] A2K: Something new
>To: "Access Developers discussion and problem solving"
>         <accessd at databaseadvisors.com>
>Message-ID: <20040122075409.551708087.serbach at new.rr.com>
>Content-Type: text/plain
>
>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