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.
Printable View
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.
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>
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>
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...