Accessing parent combo box value

electro

Registered User.
Local time
Today, 06:16
Joined
Sep 8, 2006
Messages
27
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?
 
the combo box is read by

mycomboboxname etc

if you want a different column from ther cbobox then use

mycomboboxname.columns(x)

note that the first column is column zero

----------

if the cbobox is in the parent then its

parent!mycomboboxname.columns(x)

etc
 
the combo box is read by

mycomboboxname etc

if you want a different column from ther cbobox then use

mycomboboxname.columns(x)

note that the first column is column zero

----------

if the cbobox is in the parent then its

parent!mycomboboxname.columns(x)

etc

Hey thanxs
Found the answer already on the net :)
The trick was to use the first combobox on change event and change the second combox controlsource with the choosen data.
 

Users who are viewing this thread

Back
Top Bottom