Hi

I have 2 synchronous combos, in a continuous form.

the problem is that if I change the value of the first combobox, the second combobox will be changed too, but the change will take effect in all the comboboxes, and not only in the current record of the continuous form.

hope you understand what I mean.

thank you.

No, can't say as I do entirely understand what you mean.

Do you WANT the changes to be made through all the records or not?

And what is it you mean by "synchronous" combos?

I am a loud man with a very large hat. This means I am in charge

In the continuous form I have 3 fields
Number of places(Text Field)
Car(combobox)
Driver(combobox)

whenever you fill one of those it'll requery the next combo

The cars listed are those that have equal or more places then the asked in the Number of Places field, and the Drivers listed are those that can drive the choosen car.

Now imagine a continuous form with 2 records:
Record 1
Number of places - 1
Car - VW(6 places)
Driver - Name1, abble to drive cars at maximum 9 places
Record 2
Number of places - 30
Car - Volvo(40 places)
Driver - Name3, abble to drive cars at maximum 50 places

the problem is that, when you choose in the second record the car, it will requery the combo Driver which will show you the drivers abble to drive cars with 40 or more places, but it will also requery the first record combo(which I don't want), and there was a driver not abble to drive those cars, so it'll empty the combo.

Resuming, when you do requery on a combo on a record, it also makes requery on the same combo, but in all other records, which I don't want to happen.

Hope you understand now, and sorry for my poor english

Hi Cr0vaX,
My first instinct is to ask, whether or not your combo boxes are bound.
Now correct me on this, but do you actually need 2 combo boxes. Are both used for searches or one for the search, the other for the result?
DLookUp function will work if the latter is correct, or a opening a recordset...
..but again, if my knowledge is as comprehensive as I'd like to think it is (for this question), both comboboxes must be bound in order to have an exclusive result, for each record on a form, continuous or not.
Hope this helps. Good luck!