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 &
"'")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to grab value from combo box main to enter into new record 1
SQL Problem 2
How to get combo box selected index changed event in another page from the existing page in winforms 5
Search in form 1
validation for combobox 3
Copy and Paste text? 5
Two Fields matched 2
List box question Part 2! 9

Back
Top