text box issues

[sdkramer]

I really want to have a text box to store my data, and the form I have looks up my data from a table. the table stores a Username. It's fine for me, but my coworkers would rather see a friendly name. I have an employee table to look it up in (e.g. arsmith => Amanda R. Smith) unfortunately, I can't seem to get it the way I want it. When I click the text box I get the option to choose the control source, but I can't tell anything else so my text box only gives me the option of looking at the username (which is the only thing in the table, and I can't use the associated table for a firstname & space(1) & lastname)

Ideas? Anything would be appreciated,

Seth Kramer

 

[jfgambit]

Why not use a combobox to lookup the Actual Name and the userid. The userid can be a hidden column in the combobox so all the User would see was the "nice" name, while the username was the bound column.

Use the Combobox wizard on your form to help you create the combobox.