I have the following situation:

In a Form, I have an Unbound Control whose Default Value is equal to a Bound
Control in the Record Source, but when I change from record to record, the
Unbound Control does not update (though the Bound Control does).  It stays on
whatever Default Value was put in place when the form was first opened.  Is
there any way to make the Default Value update itself?

I'm using Access 2003 on Windows XP.

Here's the background (if you need it):

A form whose Record Source is a Query that pulls from two tables.  Table 1
contains information on specific products.  Table 2 contains default
information on product types.  There is a many-to-one relationship between
Table 1 and Table 2.

I am trying to set up an interactive spreadsheet where the line item
costs/estimated income for a specific product start off as default numbers
(based on the product type), but can be changed and saved to the specific
product itself without changing the defaults.  I've set this up where the
Bound Controls for the Defaults brings the information in from the Query
(Table 2), then the Unbound Controls read the defaults and act as a
"workspace", then, when the User is ready to save, a Command button is
clicked to cause the Bound Controls of the specific record (through the Query
to Table 1) to update to whatever is currently in the Unbound controls.  It
works perfectly as long as I open one record at a time, but I need to be able
to run reports for multiple records at once, and the default values stay the
same no matter what.

Thanks in advance!