SetTempVar

[grenee]

Good Day All,

In my macro my setTempVar variable = CurrentUserID

The expression = [cboCurrentUserID]

The message box field = "you Entered " & [TempVars]![CurrentUserID]

When a button is clicked the value of the variable is not displayed.

This is displayed :"you Entered " & [TempVars]![CurrentUserID]

Can anyone guide me how to get the variable value displayed?

 

[Ranman256]

Put a text box on the form,(visible or not)
The you can get the variable anytime,any query,
Forms!myForm!txtUser


Set it at form load,
TxtUser=Environ$("Username")

 

[grenee]

I am using the Sample Northwind Database which uses the tempvar variable.

My problem is that using the action field in the macro to select the message box command the output from the variable is the tempvar name rather than its value.

I want to learn how to state the tempvar in the macro