Using a Variable

[Tee See]

If I attached an input boxprocudure to the on open event on a form and
captured the CAN/US exchange rate in a variable called varExchRate ... how
can I use that in a query?

 

[Duane Hookom]

You can expose a memory variable to a query by using a function that returns
the memory variable. You might have better luck placing the value in a
control on a form and using that control in the query:

Forms!frmYourForm!txtYourTextBox