On Tue, 20 Apr 2010 11:17:01 -0700, gravesk gravesk at coned dot com wrote:

thank you for your replies.

Karl is correct that the chosen value is not truly propagated through the
data. However it does appear to be on the form, and I want the form to show
the default value of "NOT CHOSEN" unless something else has been chosen.

I checked the data properties of the box on the form and this is what I see:

control source = location (one of the fields in the query that is my source
for the form)
row/source type = table/query
row/source = locations (name of lookup table)
bound column = 1
default value = 1
enabled = yes
locked = no

Are there other fields in the table/other controls on the form? A Default
Value will not be applied or added to the table unless the record is "dirtied"
by editing some other field.
--

John W. Vinson [MVP]