TextBox condition not working

[IMyself]

Hi there...
I got a situation and something is wrong. I dont know the problem is with the code or what.
there is a text box which is for typing id in it, and a button to go to the record of that id, and I wanted to input a condition like this:

sub CmdGotoID_Click ()

If TxtBoxID.Value = Me.ID then
msgbox "You are in this page already!"
End If
End Sub

but nothing happens when the condition is true in the form and I press the button.

 

[arnelgp]

no message displayed?

 

[IMyself]

No, Nothing Happens at all

 

[arnelgp]

maybe wrong textbox name...

 

[IMyself]

to be made sure, I did this Also:


sub CmdGotoID_Click ()
msgbox TxtBoxID.Value & Me.ID
End Sub

and in page have id 2, I did type 2 in text box and clicked the button, and a message popped showing "22" !

 

[arnelgp]

sub CmdGotoID_Click ()

If Val(TxtBoxID.Value & "") = Val(Me.ID & "") then
msgbox "You are in this page already!"
End If
End Sub

 

[IMyself]

Absolutely Right !! Thanks Dear
So why that didnt work ?? and what would the "" will do ??

 

[theDBguy]

Absolutely Right !! Thanks Dear
So why that didnt work ?? and what would the "" will do ??

Hi. Is your ID field a Text field? If so, you could try this as well:

If Me.ID = '" & Me.TxtBoxID & "'" Then