global variables

[engnouna]

Hi
I have 2 ComboBoxes in a form "frmPrompt"ne cbocategory and the other cbosubcategory
When the form loads,cbocategory displays all the categories present in an SQL table "Category"
and in the cbocategory_click,cbosubcategory displays only the subcategories corresponding to the highlighted category
sc=cbocategory.itemdata(cbocategory.listindex)
Rs1.open"Select*from SubCategory where CategoryID="&sc

but the problem is that I have another form(frmindex) which is linked to the frmPrompt
In frmindex I have a text field in which I assign a subcategory
ssubcategory=txtsub
when I hide frmindex and I show frmPrompt,I want to display the subcategory
entered in frmindex(for example if ssubcategory=Education so in the cbosubcategory I want to highlight Education when frmPrompt loads)
how can i do it?
thanks

[BrailleSchool]

Hi
I have 2 ComboBoxes in a form "frmPrompt"ne cbocategory and the other cbosubcategory
When the form loads,cbocategory displays all the categories present in an SQL table "Category"
and in the cbocategory_click,cbosubcategory displays only the subcategories corresponding to the highlighted category
sc=cbocategory.itemdata(cbocategory.listindex)
Rs1.open"Select*from SubCategory where CategoryID="&sc

but the problem is that I have another form(frmindex) which is linked to the frmPrompt
In frmindex I have a text field in which I assign a subcategory
ssubcategory=txtsub
when I hide frmindex and I show frmPrompt,I want to display the subcategory
entered in frmindex(for example if ssubcategory=Education so in the cbosubcategory I want to highlight Education when frmPrompt loads)
how can i do it?
thanks

i am not sure if this would work but something like this

frmindex.txtsub = frmPrompt.cbocategory.listindex