relating combobox and subform

[spg]

I,ve a got a problem which is ...
i,ve got a combobox which is connected to a subform and when i click combobox should appear in the subform all the information related to combobox . i don´t know how to do it dinamic.

[berta]

U can use the property form.tag of your subform to exchange the value of combo... or U can add some public properties to subform.


<center>
<HR width=80%>
<img src='http://web.tiscali.it/bertaplanet/im...ertaplanet.gif'>
</center>

[berta]

using tag.


'in main form
private sub command1_click()
mysubform.tag = mycombo.listindex
mysubform.show
end sub

'subform module
private sub form_load()
msgbox me.tag
end sub





using public properties


'in main form
private sub command1_click()
mysubform.X_listindex = mycombo.listindex
end sub

mysubform.show

'subform module

public X_listindex as long

private sub form_load()
msgbox me.X_listindex
end sub







<center>
<HR width=80%>
<img src='http://web.tiscali.it/bertaplanet/im...ertaplanet.gif'>
</center>

[spg]

Thanks, but i don´t know why but it still doesn´t work. The information that appears in the subform still the same no matter which is selected in the combobox. but is stange because no error message appears...