Lookup from Textbox

[mastromb]

So if you don't use Lookups in your tables how do you display the field you want instead of the PK.



The situation I have is as follows:

tblStates
StateID
StateAbbreviation
StateName

When I insert the StateID into my form fields as a text box I only get the primary key number. I know I can switch the form fields to combo boxes but in some instances I only want the field visible and not editable so I have set enabled to no and don't want to show the drop down list arrow.

Thanks for the help.

[Rainlover]

There is a common statement that you do not use lookups in tables.

This is a true but a bit misleading.

The statement should be, " Only use lookups in Forms "

Does this help.

[mastromb]

Well, after my scolding the other day I learned my lesson about Lookups in tables. j/k

No what I am trying to figure out is how do you accomplish a Lookup in a text box in a form to display the StateAbbreviation or StateName depending on what I want to have displayed

[Rainlover]

To be a little naughty, create a lookup in the table. Then add it to the form, then go back to the table and revert back to a text box.

I think there is also a wizard that you can use to add a combo box. There is in 2003 but I do not know about 2007

[mastromb]

Well I know how to turn the field in the form to a Combo Box and set the properties the display the right field that I want so I would be fine changing the field in the form to a Combo Box instead of a Text Box if I could turn off the arrow for the drop down list.