carmela_wong@hotmail.com wrote:[color=blue]
> 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[/color]
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
