I am having a little trouble with a form on my database. I want to be able to type in a user ID in the first field (called User ID) and then have their Last Name, Common Name, and Address appear automatically in the fields beneath. However, when I type in a User ID, let's say "HALLM", in the User ID field, the Last Name doesn't automatically change to "HALL" and the Common Name to "MICHAEL". Why not? The data for all of the users is already stored in a table (the one used to create the form).
form fields
- Thread starter wxdqz
- Start date