hello it my first time here, so I hoping I am in the right place, ok my question is how do you use a form and automatically enter data, for example I have a form called form1 for now, on this form there are two boxes one userID and the other name, when the user enters there name I want the userID to be found and placed in the box userID.
Both the name and userID are stored in a table called UserInfo. I know that I need to search the table and find the userID once the name is entered and then put it in the UserID box, but I don’t know how, thank you.

Both the name and userID are stored in a table called UserInfo. I know that I need to search the table and find the userID once the name is entered and then put it in the UserID box, but I don’t know how, thank you.
