I have some irritating problem, I have a form with a subform. Both have two comboboxes but I want the main combobox value(in my subform) to use it to filter the second combobox value. But it seems not possible. Either I get the item or the itemname of the combobox but I want the value that the main form query is having.
In short:
main form -> orderform->contacts combo
subform -> ordered stuff list -> select stuff combo
The contacts table have a secondary key to the company table.
I want to filter out in subform the stuff so you can only order stuff from the company the stuff belongs to(when selected a contact in orderform)
Do I make myself understandble?
In short:
main form -> orderform->contacts combo
subform -> ordered stuff list -> select stuff combo
The contacts table have a secondary key to the company table.
I want to filter out in subform the stuff so you can only order stuff from the company the stuff belongs to(when selected a contact in orderform)
Do I make myself understandble?