Datasheet - Pull in field value using ID linked to table

[ngonzalz]

Hello!

I am creating a Datasheet of tasks where one field is linked to a main form using an ID. Need help pulling in another field value using that ID.

tblShows
..ShowID
..Show Name

frmTasks
..ID
..ShowID - How can I display the Show Name here?
..Task



Thanks for your help!!

[John_G]

Try using Dlookup:

=Dlookup("[Show Name]","tblShows","ShowID = " & me!ID)

as the control source for the textbox to display the show name.

[pbaldy]

Another option if you use a combo:

http://www.baldyweb.com/Autofill.htm

[Gicu]

Or simply create a query linking the two tables by the ShowID.

[ngonzalz]

Try using Dlookup:

=Dlookup("[Show Name]","tblShows","ShowID = " & me!ID)

as the control source for the textbox to display the show name.

Thanks so much, this did the trick.

I was initially trying to put the code in the control source of the Show ID ... which obviously wasn't working.
I created an unbound textbox, named it Show Name, used the following code:

=DLookUp("[Show Name]","Shows","[Show ID] = " & [Forms]![dtshtTasks]![Show ID])