C
Chris
Hi,
I have a subreport in a main form.
in the before Update event of the datagrid of the subform
I want to put a value into a cell for the current record.
when I try to get the value from the main form or from a public function or
whatever:
even with a go between like this I get the error:
there was a problem accessing a property or method of the OLE object.
dim test as string
test = forms!mainform!lbluserid.caption
me.userid.value = test
as I step through the code the variable test has exactly the value I want to
go
into userid, but it pops up the error message described above.
if I hardcode the value of test it is fine. I'm perplexed considering
intellisence mouse over shows I have a perfectly valid value and the compiler
should'nt care how that value get there since the work to get the value is
done and finished long ago.
I have tried half a dozen things and they all have an OLE error.
can someone help?
I have a subreport in a main form.
in the before Update event of the datagrid of the subform
I want to put a value into a cell for the current record.
when I try to get the value from the main form or from a public function or
whatever:
even with a go between like this I get the error:
there was a problem accessing a property or method of the OLE object.
dim test as string
test = forms!mainform!lbluserid.caption
me.userid.value = test
as I step through the code the variable test has exactly the value I want to
go
into userid, but it pops up the error message described above.
if I hardcode the value of test it is fine. I'm perplexed considering
intellisence mouse over shows I have a perfectly valid value and the compiler
should'nt care how that value get there since the work to get the value is
done and finished long ago.
I have tried half a dozen things and they all have an OLE error.
can someone help?