Forms behaving badly!

[farrah]

This is supposed to be a simple form based on order details. Users can choose from 5 combobox values to get the order info on screen. Comboboxes are all based on one query. I then use the order no. to do a DoCmd filter to get the 'order header' info. The subform will then display all the related order lines for the order.
Nothing too difficult... Well this sort of works but when i Exit the form, it uses the Customer id field and updates all the records in the query with that customer id and this is really baffling me..what am i doing wrong here.

 

[Fizzio]

3 questions for you (none of them are criticism)

1. Why are you using multiple combo boxes with the same query?
2. What is the recordsource of your form
3. Do you have anything coded to the On Close event of the form?

 

[farrah]

Thanks fizzio for your reply... I have 5 coboboxes based on the same query 'cos my users find it a bit daunting to look at lots of details on the screen! so i give them the option of selecting records based on single combos (ie name or dept or order no)...
Going to your 3rd qstn I am not doing anything on CloseForm event....but your second qstn sort of holds the key..'cos my form was a bound form and i noticed 'xcaliber' had the same problem in this forum and he suggested making the form 'unbound' which is what i did and it works! And I am happy as long as things behave the way i want them to in Access.
Thanks
Farrah