I am trying to have a form in Access 97 to be linked to my one table. I want to be able to have 2 text boxes where you can either enter a users full name or his initials. Which ever you choose, the other text boxes linked to the other various fieldsin my table bring up the correct information for that username you enter. Does anyone know how to do that?
