Linking two Subforms & showing name in place of ID?

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

Flopbot

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:
www.fmsinc.com/MicrosoftAccess/Forms/Synchronize/LinkedSubforms.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?
 
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.
 
Back
Top