RecordSource Property Unavailable

Just when I thought I knew everything...

Does anyone know why sometimes when creating a subform, the
RecodSource property is totally unavailable, this appears to happen
when you don't use the subform wizard. Instead of a "RecordSource", it
is "SourceObject"(query or table). I am creating a database for
someone that does not have the access wizard installed (normally I
don't use it much anyways) and when I create a subform and want to
specify the RecordSource property I can't because it doesn't exist and
I don't want it based on a "SourceObject". Any help is greatly
appreciated.

Thank You!
Jeremy

Just for the record, there is no such thing as a "Subform object"... there
is a Subform Control, which has a Source Object (specifies what Form is
embedded in the Subform Control -- that Form will have a RecordSource, but
you'll have to open it directly; don't ask me what those values are if you
choose the datasheet option, as IMNSHO, you should present a Form to the
user).

Regardless of whether the Wizard is installed, the Subform Control should
have a Source Object and the Form embedded in the Subform Control, opened
separately, should have a RecordSource.

Larry Linson
Microsoft Access MVP


"Mr. Bungle" <slayer3600@hotmail.com> wrote in message
news:aba497b8.0408021532.769b1851@posting.google.c om...[color=blue]
> Just when I thought I knew everything...
>
> Does anyone know why sometimes when creating a subform, the
> RecodSource property is totally unavailable, this appears to happen
> when you don't use the subform wizard. Instead of a "RecordSource", it
> is "SourceObject"(query or table). I am creating a database for
> someone that does not have the access wizard installed (normally I
> don't use it much anyways) and when I create a subform and want to
> specify the RecordSource property I can't because it doesn't exist and
> I don't want it based on a "SourceObject". Any help is greatly
> appreciated.
>
> Thank You!
> Jeremy[/color]

The Record Source would be the data source for the subform, the Source
Object would be the form you are placing in the subform control on the main
form. If you have duplicate names, such as the subform control having the
same name as the form it is holding, this may be causing confusion. To refer
to a subform from the main form the syntax would be:

Me!NameOfSubformControl.Form.RecordSource

If you created the subform on the main form by dragging and dropping the
form onto the main form, Access will create a subform control that has the
same name as the form you dropped onto the main form and set the controls
Source Object to the form you dropped.

--
Wayne Morgan
Microsoft Access MVP


"Mr. Bungle" <slayer3600@hotmail.com> wrote in message
news:aba497b8.0408021532.769b1851@posting.google.c om...[color=blue]
> Just when I thought I knew everything...
>
> Does anyone know why sometimes when creating a subform, the
> RecodSource property is totally unavailable, this appears to happen
> when you don't use the subform wizard. Instead of a "RecordSource", it
> is "SourceObject"(query or table). I am creating a database for
> someone that does not have the access wizard installed (normally I
> don't use it much anyways) and when I create a subform and want to
> specify the RecordSource property I can't because it doesn't exist and
> I don't want it based on a "SourceObject". Any help is greatly
> appreciated.
>
> Thank You!
> Jeremy[/color]

Mr. Bungle, Open you main form in design view. Select the little box in
the upper left-hand corner of your subform control. You may have to click
the subform twice. The first time will select the subform control the
second click(in the upper-left-hand little box) will place a little black
dot in the box. Now select View/Properties from the main menu. You can
then set the Subform Controls Source Objects(which is your form),
recordsource! Hope this helps.

--
Reggie

----------
"Mr. Bungle" <slayer3600@hotmail.com> wrote in message
news:aba497b8.0408021532.769b1851@posting.google.c om...[color=blue]
> Just when I thought I knew everything...
>
> Does anyone know why sometimes when creating a subform, the
> RecodSource property is totally unavailable, this appears to happen
> when you don't use the subform wizard. Instead of a "RecordSource", it
> is "SourceObject"(query or table). I am creating a database for
> someone that does not have the access wizard installed (normally I
> don't use it much anyways) and when I create a subform and want to
> specify the RecordSource property I can't because it doesn't exist and
> I don't want it based on a "SourceObject". Any help is greatly
> appreciated.
>
> Thank You!
> Jeremy[/color]

Dude you guys are sweeeeeet thankyou so much :-)