Combox Problem

[ctkmak]

I have created a combox box based on customter name for selecting related customer sales records (a single customer may have multiple sales records).
When I click the "Close" button, I don't know the reason why first record in the list being updated, eventhough it have not been selected.

Actually, I have read the tip in this forum about using Requery. But, I don't know how to apply Requery to multiple record enviornment in order to avoid undesired updating.

 

[WayneRyan]

ctk,

It sounds like you're using a combo box to search for customer records.

If, when you click the "Close" button, and the first record is being
updated, it probably means that the combobox is "bound" to the recordset.
If you are using it to search, it should have no ControlSource.

What is the ControlSource of the combo?

Wayne

 

[ctkmak]

Dear Wayne,
I have used the customer name as control source. When I select the customer name, the subform will show me a list of correct sales records in the subform. Then, when I click the another customer name, the program is still able to show me the correct sales record. But, when I click the "Close" button the recent customer name has update my first customer name in the database. Do you know why the system will update the previous record which has been selected ?

 

[ctkmak]

I have already resolved my problem, it is due to the control source issue because I have put the customer name field into control source that it will automatic prompt the first record to me. Thus, the record pointer pointed to my first record upon I close the form.

Wayne, Thanks you for help