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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|