Link two subforms in datasheet view (one sub-form, one sub-subform

  • Thread starter Thread starter Flopbot
  • Start date Start date
F

Flopbot

I’d like to know if this is even possible. I have a form named “Frm
Volunteer Opportunities†with a subform named “SubFrm Volunteer
Opportunitiesâ€. The subform must remain in datasheet view and has fields
like: [Event ID], [Event Date], [Start Time], [End Time], etc... I want to
link another form (a sub-subform?) to the datasheet so that whenever my
curser is located in one of the datasheet rows, this other form will present
all volunteers scheduled for that event. Then, when you move the curser to
the next row, those names would change. I’m guessing this means that the
mystery form will also need to remain in datasheet view. This third form
will have fields like [Event ID], [Volunteer ID], [First Name], [Last Name],
etc... Clicking the + sign on each row to view this data isn’t my ideal
preference.

Any advice, hints, or nudges to get me started would be greatly appreciated!
 
I’d like to know if this is even possible. I have a form named “Frm
Volunteer Opportunities” with a subform named “SubFrm Volunteer
Opportunities”. The subform must remain in datasheet view and has fields
like: [Event ID], [Event Date], [Start Time], [End Time], etc... I want to
link another form (a sub-subform?) to the datasheet so that whenever my
curser is located in one of the datasheet rows, this other form will present
all volunteers scheduled for that event. Then, when you move the curser to
the next row, those names would change. I’m guessing this means that the
mystery form will also need to remain in datasheet view. This third form
will have fields like [Event ID], [Volunteer ID], [First Name], [Last Name],
etc... Clicking the + sign on each row to view this data isn’t my ideal
preference.

Any advice, hints, or nudges to get me started would be greatly appreciated!
Click to expand...

You need two correlated subforms. I'm not certain that Datasheet view will
work; if not, you can make a Continuous Form look very much like a datasheet
(and it's worth a try).

They will both need to be Subforms of [frm Volunteer Opportunities]. Put a
textbox txtRelay on the master form, and set its Control Source to

=[SubFrm Volunteer Opportunities].[Event ID]

You can set its Visible property to false if you wish.

Put the third form next to the first subform in a subform control; set that
control's Master Link Field to

[txtRelay]

The wizard won't offer this as an option, just type it in. Set the child link
field to [Event ID].
 
Back
Top