Norm,
You dpn't say how many different Chstat values there may be, but if more
than 5 or so, it would be a candidate for a combo box, (ex. cboChstat)
based against a table of preset values. Ex. tblChstat...
Chstat Desc
10 Printed
20 Located... etc
Bind cboChstat to your Chstat field of your table, and use the combo to
select a Chstat value. An unbound text control on the form, with a
ControlSource
of...
=cboChstat.Colunm(1)
will always display the contents of the 2nd column in cboChstat. (combo
columns are numbered left to right 0, 1, 2, 3, etc.)
No need to save Desc... it can always be re-related to from the Chstat
value
in any subsequent query, form, or report.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."