A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old April 24th, 2010, 02:06 AM posted to microsoft.public.access.forms
Flopbot
external usenet poster
 
Posts: 60
Default Link two subforms in datasheet view (one sub-form, one sub-subform

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!
  #2  
Old April 24th, 2010, 04:19 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Link two subforms in datasheet view (one sub-form, one sub-subform

On Fri, 23 Apr 2010 18:06:01 -0700, Flopbot
wrote:

Id 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. Im 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 isnt my ideal
preference.

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


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].
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.