Passing a number to retrive the name in a table

[Guest]

Im trying to figure out how to retrieve the name from a team member table if
i pass it the id number.


~TeamMember~
TeamMemberID as number
Name as text

 

[Douglas J. Steele]

Retrieve where?

In a query, join the two tables together on TeamMemberID.

In VBA, you can use DLookup("[Name]", "[TeamMember]", "[TeamMemberID] = " &
IdNumber)

Note that Name isn't a very good choice for a field name: it's a reserved
word.

 

[Guest]

thanks

Retrieve where?

In a query, join the two tables together on TeamMemberID.

In VBA, you can use DLookup("[Name]", "[TeamMember]", "[TeamMemberID] = " &
IdNumber)

Note that Name isn't a very good choice for a field name: it's a reserved
word.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Im trying to figure out how to retrieve the name from a team member table
if
i pass it the id number.


~TeamMember~
TeamMemberID as number
Name as text