ca**********@hotmail.com wrote:
Here is what happens: I look up an Order number on the main form. The
subform shows all the line items for that order. It is that subform
that has the combo box. I want it to show USA as the default which
then gets saved in the country field of each record for the order.
Country could be changed to Canada or Mexico prior to saving. The
wierd thing I just noticed is that the value does not get saved in
the country field unless I go and select country value for each line
individually. It does not just save the default value in the field.
Thanks
The default value only applies to NEW records. If you added this field and
ComboBox and then look at existing orders it is going to still show null
because that is the value stored in those records. If you look at the last
"new record" row on your subform you should see the default value show up
there.
For existing records you would need to run an update query to set them all
to USA and then you could use the ComboBox on individual records that needed
to be set to something else.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com