Changing multiple fields with one control

My job requires us to print out routing sheets with detailed information
about commitments and send out letters based on that information. I have a
certain piece of information that needs to show up in different formats (full
spelled out name and it's abbreviation). We're trying to cut down on
mistakes, so we're using combo boxes for as much as we can, and this field is
one of them. Right now we have two drop down boxes, one for the spelled out
name and one for the abbreviation. I want to be able to use just one drop
down menu to populate both the spelled out column and the abbreviation
column. Is this possible?

Actually, you should only be storing this information in one place -- in
it's own table. Then you just store the primary key of this table (I'd
suggest an autonumber field) in the main table and join these tables back
together when you want the abbreviation and spelled out name.


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"avarusbrightfyre" wrote in
message ...
My job requires us to print out routing sheets with detailed information
about commitments and send out letters based on that information. I have
a
certain piece of information that needs to show up in different formats
(full
spelled out name and it's abbreviation). We're trying to cut down on
mistakes, so we're using combo boxes for as much as we can, and this field
is
one of them. Right now we have two drop down boxes, one for the spelled
out
name and one for the abbreviation. I want to be able to use just one drop
down menu to populate both the spelled out column and the abbreviation
column. Is this possible?