Forms and subforms updating

rarejoep

Registered User.
Local time
Today, 22:51
Joined
Oct 8, 2002
Messages
30
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?
 
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
 
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.
 
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
 

Users who are viewing this thread

Back
Top Bottom