Northwind Combo box question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the Orders Form of the Northwind DB, how is that the Customer Combo box is
able to be selected, yet doesn't change any data in the Query which the form
is Based on (Orders Qry). Is it because the Form is based on a query? Is it
because the rowsource of the combo box is set to "Select Distinct"?
 
It might seem like it doesn't update the record, the form open in and order
by customer, so everytime you update the customer, the next time you load the
form, the form load another order for this customer, so it look like the
order doesnt update.
I tried it, and after I updated all of the customer orders it moved to the
next customer
 
Is there a way to select the records in the combo box, without updating the
query or record? I want to use the combo box as a look up, not for updating
of any nature. Is this possible? I have done this in other VBA, using text
files, but never in Access.
 
You can Undo the changes that been done to the all the record on the unload
event of the form.
Or make the combo Unbound, so all the changes wont be saved, you'll need to
assign a value to the combo on the OnCurrent event of the form.
 
Back
Top