Full Version: linking to table from form
UtterAccess Forums > Microsoft® Access > Access Forms
edojan
ok here is the issue
I have userid on main table which is in form main. I have another table users which has userid and username.
from the main form how can i create a text box that will check userid on main table and link to username in the users table?
thanks!
theDBguy
How about DLookup?

=DLookup("username", "users", "userid = " Me.userid)

HTH.
Edited by: theDBguy on Thu Aug 16 11:54:43 EDT 2007.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.