By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,335 Members | 1,895 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,335 IT Pros & Developers. It's quick & easy.

How to make ComboBox selection save?

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.