Dlookup?

  • Thread starter Thread starter Tom T
  • Start date Start date
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.
 
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 &
"'")
 
Back
Top