Forms and subforms updating

[rarejoep]

I have managed to make a pulldown list with carID's where you can choose a car. Below this, a table is showed with elements concerning the car. When you change the car, the table also changes.
But here's the problem: the elements from the list are updated when I enter new data in the tables. When I enter information of the same car, the list contains 2 the same cars. This is not what I want. I can't solve it with setting the Index of the collumn to Yes (no duplicates) because they may exist.
Has anyone an idea?

 

[ColinEssex]

Just to clarify what you are saying-

You have a ComboBox listing car names e.g. Ford Mondeo
and you have a subform that lists the selected car's specification- e.g. air-con,electric windows

But you have another car (same name) e.g. Ford Mondeo with a different specification e.g. no air-con. Yet in the ComboBox you have 2 Ford Mondeo's in the list. But you only want one to show in the ComboBox but you want both specifications?

Col

 

[rarejoep]

Yep, that's right.
Meanwhile I have made a query which doesn't allow duplicates and used that as input for the list, but I am not sure if this is the right way to do.

 

[ColinEssex]

Yes you can do but if there's only one Ford Mondeo and you select "Ford Mondeo" from the ComboBox - how does it know what specification to put in the subform if there's more than one?

Col