How to lookup state abbreviation codes

[DAZarlengo]

I have a table with two columns. One column is state names spelled out. The other is the 2 character abbreviations. In a form, when adding new clients to a table, how do I let the user scroll through the list and store only the 2-character abbreviation in a client table.

 

[SydneyGeek]

Make the 2-letter abbreviation the ID column for the table. Then, when you create combos for data entry, you can show users the full State names for ease of reading -- but the abbreviations will be stored.
If you haven't done it before (assuming you are using a form for data entry), do this:
1. In Design view on the form, and with Wizards enabled, click the Combo on the toolbox and click the desired location on the form.
2. The wizard will launch -- follow the prompts. You'll want to use the abbreviation and name fields, and hide the key field.

HTH
Denis

 

[DAZarlengo]

Thanks Sidney! That did the trick. I've been away from Access for a year, and just couldn't remember the approach.

 

[DAZarlengo]

Sorry about that - should have been Thanks Denis!

 

[SydneyGeek]

No worries