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!

How about DLookup?

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

HTH.

Edited by: theDBguy on Thu Aug 16 11:54:43 EDT 2007.