How to make ComboBox selection save?

[George Raetz]

Greetings,
I open the "Northwind" sample data base in Access 2003. In the "Orders" form
there is a "CustomerID" combobox labeled "Bill To". I scroll thru the list
in the combobox and make a selection; that changes the appropriate fields
in the displayed record. However, when I close the form and reopen it, the
record reverts back to the original data. Even with menu choice "Save
Record" the modified data is not changed.
Is this normal data base behavior? If so, is there a non-VBA fix so that the
modified record saves?
Thanks in advance,
George

[David Schofield]

On Sat, 22 Jan 2005 10:49:20 -0700, "George Raetz"
<be********@pcisys.net> wrote:

Greetings,
I open the "Northwind" sample data base in Access 2003. In the "Orders" form
there is a "CustomerID" combobox labeled "Bill To". I scroll thru the list
in the combobox and make a selection; that changes the appropriate fields
in the displayed record. However, when I close the form and reopen it, the
record reverts back to the original data. Even with menu choice "Save
Record" the modified data is not changed.
Is this normal data base behavior? If so, is there a non-VBA fix so that the
modified record saves?
Thanks in advance,
George

Hi
I think you will find that when you reopen the form it is set to a
different order with the same billto address. There are several orders
with the same billto addresses, and the form is sorted in alphabetic
order of billto address, so until you have changed quite a few the
form reopens with the same one.
David