J
Jerry Qu
Trying to work around the problem with the previous post. I just found I can
not call public sub(function) of subform from the main form too:
in the subform
Public Sub fillData(strSQL as String)
msgbox strSQL
.....
end sub
in the main form:
Me!subfrmControlName.form.fillData strSQL
get error....
but it works fine without parent/child relation:
forms!subformName.fillData strSQL
please help
TIA
Jerry
not call public sub(function) of subform from the main form too:
in the subform
Public Sub fillData(strSQL as String)
msgbox strSQL
.....
end sub
in the main form:
Me!subfrmControlName.form.fillData strSQL
get error....
but it works fine without parent/child relation:
forms!subformName.fillData strSQL
please help
TIA
Jerry