Retain string for further use

C

Craig Ferrier

I have a form which compiles an sql query when entering data into a form - a
public function "RunFilter()". It creates a string "strw". I want to use
this string for another event "after update" event on a option box in the
same form.

if the string length is > 0 then I want to it to run the public function
"RunFilter()"

How do i do this?

Craig
 
J

J. Goddard

Why not have the function return the string as the function value?
So, in the function, you will put RunFilter = strw
and in your form, you can use: mystring = runfilter()

Another option is to make strw a global (public) variable.

Hope this helps

John
 
Top