Text Box Data

[Melbourne]

I have a text box that displays staff ID number. Is code or an expression
that makes it possible to get the text box to read the staff name from the
staff table.

Thanks

 

[Allen Browne]

You didn't like the answer you got to this question 6 hours ago?

 

[Steve Schapel]

Melbourne,

A few approaches to this are discussed in this article:
http://accesstips.datamanagementsolutions.biz/lookup.htm

 

[Melbourne]

Allen,

Sorry, I couldn't find my first post so I thought that it hadn't gone
through, hence the second post.

The DLookup() assistance worked perfectly, thank you for your assistance