Using a Variable

T

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?
 
D

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
 
Top