subforms

[Bill H.]

Currently using access 2000. I'd like to have a subform on a form, where
the default view of the form is set to continuous (as is the view of the
subform). Naturally, Access doesn't like that.

My first question is whether this is "solved" in later versions of Access.

If not (or even if), how do I implement that ability using Access 2000? And
the kicker is that I would like this form (with its subform) to be a subform
on the main parent form.

The design is for public services offering, where a family (parent form) has
many services they can choose to participate in (subform) and each of those
services have scheduling dates (start/stop) and a field for
accept/decline/waitlist (the subform on the subform). Thus a family could
choose a service on a date, and after review be denied (on a date), but
subsequently (on another date) be waitlisted, and then on yet another date
be accepted. The history of this accept/decline/waitlist needs to be
tracked.

Thanks!

 

[tina]

you can put two subforms on the main form. link subform1 to the mainform
with the LinkChildFields and LinkMasterFields properties in the subform
control, as usual. add an unbound (and invisible) textbox control to the
main form, and set its' ControlSource property to the primary key field of
subform1, as

=[Subform1ControlName].[Form]![PrimaryKeyFieldName]

replace "Subform1ControlName" with the correct name of the subform control
on the mainform - NOT the name of the subform as it shows in the database
window. the two names may be the same, or they may be different, so make
sure you're using the correct name in the expression above. and replace
"PrimaryKeyFieldName" with the correct name of the primary key field in
subform1's RecordSource.

set the LinkMasterFields property of subform2 to the name of the unbound
textbox control on the main form. set the LinkChildFields property to the
name of the foreign key field in subform2's RecordSource, as you normally
would.

now subform2 is linked to subform1, just as though it were "sitting inside"
subform1.

hth

 

[Bill H.]

Thanks.

Sounds pretty cool.

 

[tina]

you're welcome

Thanks.

Sounds pretty cool.

you can put two subforms on the main form. link subform1 to the mainform
with the LinkChildFields and LinkMasterFields properties in the subform
control, as usual. add an unbound (and invisible) textbox control to the
main form, and set its' ControlSource property to the primary key field of
subform1, as

=[Subform1ControlName].[Form]![PrimaryKeyFieldName]

replace "Subform1ControlName" with the correct name of the subform control
on the mainform - NOT the name of the subform as it shows in the database
window. the two names may be the same, or they may be different, so make
sure you're using the correct name in the expression above. and replace
"PrimaryKeyFieldName" with the correct name of the primary key field in
subform1's RecordSource.

set the LinkMasterFields property of subform2 to the name of the unbound
textbox control on the main form. set the LinkChildFields property to the
name of the foreign key field in subform2's RecordSource, as you normally
would.

now subform2 is linked to subform1, just as though it were "sitting inside"
subform1.

hth