using a string instead of a textbox

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

My forms on current event has a calculation that saves to a string. I would
like to use this string in a query. The problem is, when I try referencing
the string...the query acts like it does not recognize it..it asks me for
the strings value. I can make it work by having the string save to a
textbox's value and then reference the textbox in the query. Although by
doing it this way I have a textbox on my form that I don't need. Seems
unnecessary.

Is there a way to use a string in a query instead of referencing the textbox
on a form?
I do have the string defined as public
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Queries can only read the variable returned from a user-defined
functions, not public variables. You could define the string as a
public string and then create a public function that returns that
string. Then use that function in a query to get the string.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQRSWyIechKqOuFEgEQJJDQCgtEbBeXGD5wbehldap0L60u8aSbgAoPGr
G4l/FRGgAczCYia8gUaEhj7E
=6Og2
-----END PGP SIGNATURE-----
 
Back
Top