Invalid Reference Error

Thanks for the reply, but you are off base here. A public function in a
subform can be called in the manner I described. I have used it for years in
many systems. My problem is NOT that it never works. It works fine thousands
of times a day.
If it did not, then the entire system would be useless. It is only once in a
while that I get the errors.

--

AG
Email: npATadhdataDOTcom


"AccessVandal via AccessMonster.com" u18947@uwe wrote in message
news:9a1edb31aee58@uwe...
PS. You can't call a function/subroutine from the mainform if the function
is
in the subform. You can put it as a public function all you want but as
far
as the form's module are concern, it is private and known only to the
form's
module and can only be called the the form's module no where else.

If you want it as a Public function, put into a Standard module and you
can
called it from any where from your form's module.

AG wrote:
Thanks for the reply.
I think I will try moving the subform's public function to the main form,
even though it will probably only move the error to a different place. The
function changes the recordsource of the subform, to it still needs to be
referenced.

The big thing with all of this is that the syntax is all correct and it
all
runs thousands of times each day. Only once in a while does it error out.
That is why I mentioned the network. I wonder what happens within Access
when code is running and the network hiccups while Access is trying to get
a
different record from the back end.

With this kind of code you'll get errors like "(You entered an
expression
that has an invalid reference to the property Form/Report)"
[quoted text clipped - 19 lines]

I will need to get permission from the client to provide you with a
copy.

--
Please Rate the posting if helps you.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200908/1

Well, that's good but so far it doesn't work for me.

Besides Hardware/network issues did you do a compact and repair as well as
decompile?
See Tony Teow's site on performance, may not help but will give you some
ideas about your problems.
http://www.granite.ab.ca/access/performancefaq.htm

and how to decompile
http://www.granite.ab.ca/access/decompile.htm

Lets hope Mark Han has a solution for you.

AG wrote:
Thanks for the reply, but you are off base here. A public function in a
subform can be called in the manner I described. I have used it for years in
many systems. My problem is NOT that it never works. It works fine thousands
of times a day.
If it did not, then the entire system would be useless. It is only once in a
while that I get the errors.

PS. You can't call a function/subroutine from the mainform if the function
is
[quoted text clipped - 29 lines]
I will need to get permission from the client to provide you with a
copy.

--
Please Rate the posting if helps you.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200908/1

Thanks,

I moved that one routine out of the subform, just to see if anything
changes.
Yes, I never deploy an application without doing a decompile,
compact/repair, compile, compact/repair.
Also do it several times during long development.

--

AG
Email: npATadhdataDOTcom


"AccessVandal via AccessMonster.com" u18947@uwe wrote in message
news:9a2c5d59d1652@uwe...
Well, that's good but so far it doesn't work for me.

Besides Hardware/network issues did you do a compact and repair as well as
decompile?
See Tony Teow's site on performance, may not help but will give you some
ideas about your problems.
http://www.granite.ab.ca/access/performancefaq.htm

and how to decompile
http://www.granite.ab.ca/access/decompile.htm

Lets hope Mark Han has a solution for you.

AG wrote:
Thanks for the reply, but you are off base here. A public function in a
subform can be called in the manner I described. I have used it for years
in
many systems. My problem is NOT that it never works. It works fine
thousands
of times a day.
If it did not, then the entire system would be useless. It is only once in
a
while that I get the errors.

PS. You can't call a function/subroutine from the mainform if the
function
is
[quoted text clipped - 29 lines]
I will need to get permission from the client to provide you with a
copy.

--
Please Rate the posting if helps you.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200908/1