Hi guys and gals,
I was wonderijg if you could help me in my hour of need.
I have two comboboxes -com31 and com32. Following the change (update) of com31 I want to requery com32, and retrieve the corresponding value from the database using com31 as a parameter. I've got that bit working. But after com32 is "requeried" it doesn't repopulate with the value retrieved in the query.
The value is in the com32 combobox list drop down, but just doesn't appear in the combobox itself as a com32.value. The requery only ever retrieves one value and I would like this to go into com32 as a value.
Please don't suggest a single field instead of combobox because once the com32.value is repopulated via the query, I will then change the query source again so that the dropdown list contains multivalues.
Any bright ideas would be welcome - cheers!
I was wonderijg if you could help me in my hour of need.
I have two comboboxes -com31 and com32. Following the change (update) of com31 I want to requery com32, and retrieve the corresponding value from the database using com31 as a parameter. I've got that bit working. But after com32 is "requeried" it doesn't repopulate with the value retrieved in the query.
The value is in the com32 combobox list drop down, but just doesn't appear in the combobox itself as a com32.value. The requery only ever retrieves one value and I would like this to go into com32 as a value.
Please don't suggest a single field instead of combobox because once the com32.value is repopulated via the query, I will then change the query source again so that the dropdown list contains multivalues.
Any bright ideas would be welcome - cheers!
