Dlookup?

T

Tom T

In a form:
I have two text boxes (txtname, txtcontrollocation). I am
trying to have the "txtcontrollocation" populate from a
table (Security Infomation) using the "txtname"
information.

Your help is greatly appreciated.
 
R

Rick Brandt

Tom T said:
In a form:
I have two text boxes (txtname, txtcontrollocation). I am
trying to have the "txtcontrollocation" populate from a
table (Security Infomation) using the "txtname"
information.
Click to expand...

=DLookup("txtcontrollocation", "[Security Infomation]", "txtname = '" & me!txtname &
"'")
 
Top