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  

Linking two Subforms & showing name in place of ID?



 
 
Thread Tools Display Modes
  #1  
Old May 7th, 2010, 10:49 PM posted to microsoft.public.access.forms
Flopbot
external usenet poster
 
Posts: 60
Default Linking two Subforms & showing name in place of ID?

This is a repost of a question that apparently didn’t go through on 5/1/2010.

I have an unbound form with two subforms on it [SubFrm Actual Volunteers] &
[SubFrm Volunteer List]. These two subforms are linked together using a text
box on the main unbound form called [Event ID].

To do this, I followed the directions (half way down the page) on:
http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[SubFrm Actual Volunteers] :
~Master
~Has fields like [Volunteer ID] & [Event ID].
~Also has a combo box [Name] with the row source: SELECT [Tbl Vol
Info].[Volunteer ID], [Tbl Vol Info].FirstName & " " & [Tbl Vol
Info].LastName FROM [Tbl Vol Info] ORDER BY [FirstName], [LastName]; which
displays the actual name on the subform instead of just the ID #.
~This one is actually a sub-sub form of [SubFrm Vol Opportunities]
~Data taken from [Tbl Actual Volunteers].

[SubFrm Volunteer List]:
~Child
~Has fields like [Volunteer ID] & [Event ID].
~This subform is just used for reference and not for data entry.
~Data taken from [Tbl Actual Volunteers].

My question is, how can I make [SubFrm Volunteer List] display [Volunteer
ID] as a name? I don’t believe I can use the combo box solution that worked
for my master since I’m not actually entering any data her. Should I use
DLookUp instead or is there another way to do this?


  #2  
Old May 10th, 2010, 02:37 PM posted to microsoft.public.access.forms
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default Linking two Subforms & showing name in place of ID?

Flopbot -

Change the recordsource for [subFrm Volunteer List] from the table to a
query that joins [tbl Actual Volunteers] to [Volunteer ID], and then the
fields will be there for you to put on the form. You can click on the
elipses (...) to the right of the record wource property to do this.

--
Daryl S


"Flopbot" wrote:

This is a repost of a question that apparently didn’t go through on 5/1/2010.

I have an unbound form with two subforms on it [SubFrm Actual Volunteers] &
[SubFrm Volunteer List]. These two subforms are linked together using a text
box on the main unbound form called [Event ID].

To do this, I followed the directions (half way down the page) on:
http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[SubFrm Actual Volunteers] :
~Master
~Has fields like [Volunteer ID] & [Event ID].
~Also has a combo box [Name] with the row source: SELECT [Tbl Vol
Info].[Volunteer ID], [Tbl Vol Info].FirstName & " " & [Tbl Vol
Info].LastName FROM [Tbl Vol Info] ORDER BY [FirstName], [LastName]; which
displays the actual name on the subform instead of just the ID #.
~This one is actually a sub-sub form of [SubFrm Vol Opportunities]
~Data taken from [Tbl Actual Volunteers].

[SubFrm Volunteer List]:
~Child
~Has fields like [Volunteer ID] & [Event ID].
~This subform is just used for reference and not for data entry.
~Data taken from [Tbl Actual Volunteers].

My question is, how can I make [SubFrm Volunteer List] display [Volunteer
ID] as a name? I don’t believe I can use the combo box solution that worked
for my master since I’m not actually entering any data her. Should I use
DLookUp instead or is there another way to do this?


 




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 06:41 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.