How do I move data between variables and queries?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sjw - 12 Apr 2005 16:59 GMT

I have a global variable "xxxx" and want to reference its value in the
criteria of a query. I was thinking of;

Like '*' & [forms]![CloseItem].[xxxx].[value]

I also have a different variable "yyyy" and want to set its value to the
result of a single field from a query. I was thinking of;

DoCmd.OpenQuery "someQuery"
yyyy = queries!someQuery!FieldName

Reply to this Message

Ofer - 12 Apr 2005 17:08 GMT

Create a Global Function that return the variable
Function aaaaa()
aaaaa="xxxx"
End Function

and now you can call your function in your query and get
the value of "xxxx"

>-----Original Message-----
>I have a global variable "xxxx" and want to reference its value in the
[quoted text clipped - 9 lines]
>
>.

Reply to this Message