Display one field when entering another

[kbrooks]

I have a form that asks in one field for a UserID, from a table called Users. Another field in that table is called UserName, and I'd like to have that automatically populate with their name when you enter the UserID. I know this is possible and is probably relatively simple, but I'm having no luck so far. Any help is much appreciated!

 

[JCollins]

You could use a dlookup, but that is slow.

It is probably better to include the UserName in the recordsource of the form and then set the textbox's control souorce to UserName. When you enter a UserID, the UserName should automatically fill in.

Good Luck!