Text Box Value in Msgbox ? Arg ?

[redbull]

Alright, I am trying to do this...

Msgbox " Is This User in the List?" & Forms("frmmainnew").txtlast1234.Value

This does not give me a syntax error.. but when the code is running nothing is popping up... The msgbox is not in an IF statement, So I really don't know what is going on... If I try this...

Msgbox " Is This User in the List?" & Forms("frmmainnew").txtlast1234.Value &

Or

Msgbox " Is This User in the List? & Forms("frmmainnew").txtlast1234.Value & "

I get syntax errors? Any ideas???

[ssanfu]

Both of these give me the message dialog box:

MsgBox " Is This User in the List? " & Forms("activity").StreetNo

'if on the same form
MsgBox " Is This User in the List? " & Me.StreetNo

Obviously, activity & StreetNo are my form and text box names
BTW, ".Value" is not needed because the value property is the default property. Doesn't hurt but not necessary.

[redbull]

lol thank you... I need more caffeine... I had the textbox named wrong... WOW

[ssanfu]

Great...

Here you go .....