Pass a value from a text control on a form to a variable in a module of a report

[Jason M Canady]

Hi all,

i am trying to pass a value entered into an unbound form to a report called
from that form. I cannot seem to get it to work.
I though that I should be able to reference the form control, but cannot
seem to find a way to get that to work either! The form is still running
behind the open report.
Can someone point me in the right direction? I am hoping that I do not need
to overload the method to pass the variable to report, as it just seems like
more work than should be needed...
Any assistance would be greatly appreciated.
TIA,
Jasonm

 

[Guest]

I am sure there must be more to this but you just reference it with
[Forms]![FormName]![ControlName]

 

[Jason M Canady]

Thank you dennis!

It never ceases to amaze me how I can overlook the simplest things... I was
so close only forgot to reference that actual form name and then tried with
the form name, the control name and then the property where the value should
have been stored... just not the combination that you gave me!

That did the trick and I will definately remember it this time!!!

Thanks again, Jasonm

I am sure there must be more to this but you just reference it with
[Forms]![FormName]![ControlName]

Hi all,

i am trying to pass a value entered into an unbound form to a report
called
from that form. I cannot seem to get it to work.
I though that I should be able to reference the form control, but cannot
seem to find a way to get that to work either! The form is still running
behind the open report.
Can someone point me in the right direction? I am hoping that I do not
need
to overload the method to pass the variable to report, as it just seems
like
more work than should be needed...
Any assistance would be greatly appreciated.
TIA,
Jasonm