Referencing a form variable in VB code

[FrancieFL]

I have an unbound field called "[Initials In]" which I am trying to us in a SELECT and SET statement. I have tried "ME![Initials IN]" but VB doesn't seem to get the value of the field.

My sub statement is:
Public Sub GetNumber_Click()

and the WHERE statement is:
"WHERE (Left([Customer_Code],2)=Me![Initials_In]); "

Is this not the correct way to reference the variable?

Is there and instruction that I can put in my VB code that will allow me to display the value of my variable, for testing purposes?

Sorry for all the questions, but I am new to Access.
Francie

 

[Rick39]

Try:

"WHERE (Left([Customer_Code],2)='" & Me![Initials_In] & "'); "

 

[FirstAndGoal4]

To display the value for testing, you could do

msgbox Me![Initials_In]

or just put a breakpoint on that line and use the immediate or watch windows.

 

[FrancieFL]

Thanks for the help.
Francie