Forms combox and same recrod with different crietria

[DevAccess]

Hello

i have combobox which has value like below


VendorID Value
1 Malysia
1 Japan
1 Singapore
2 South America

When I select value from combox it should populate fields on the form with both of the above value.

But when it always populate first value for example if i select first record as above it populates 1 malysia but when I select 1 Japan it does not change accordingly

Pleaes note that vendorID and Value are composition of different table.

Can you please help me how to make this work it should always populate the field values as per selection.

Thanks

 

[stopher]

A combobox only stores one value. In you case I guess it is storing VendorID i.e. a value of 1. So regardless of which of the first three options selected, the value stored is still 1. And when it comes to display, it will choose the row in the list with the value 1 which in your case is Malysia.

If you want to store two independent values, use two combos. Or use a key to identify the pair.

hth

 

[DevAccess]

A combobox only stores one value. In you case I guess it is storing VendorID i.e. a value of 1. So regardless of which of the first three options selected, the value stored is still 1. And when it comes to display, it will choose the row in the list with the value 1 which in your case is Malysia.

If you want to store two independent values, use two combos. Or use a key to identify the pair.

hth

No, I have query which is associated with the form and fields are bound to that query, so if user selects the value from combobox it should change the value on the form accordingly.

but that is not happening.