Compare two txtbox vba Access

[Ubrukelig]

if txtbox1.value = txtbox2.value then
msgbox "Equel" Else
msgbox "Unequel"
end if


How to make this work in vba access?

[Luk3r]

Your solution should work, with the possible exception of the location of "Else":

If TxtBox1.Value = TxtBox2.Value Then
MsgBox "Equal"
Else
MsgBox "Not Equal"
End If

[Ubrukelig]

I still godt error when i try this code in the button. The expression on clicks that you have selected as the event property, causing the error Outside of a procedure invalid. What do i do wrong?

[Luk3r]

Can you share all of your code? That error is because you're writing code outside of a procedure, as stated, or you're missing a fine detail (misspelled resume/exit).

[Ubrukelig]

I have no more code than you see when I do not know enough about vba to know what it takes to get the code I have posted to work. I have only two textboxes who work like this, I click the button, it comparing values. I do not know how proseduren should be written. I've tried long to find answers to this challenge.

[Ubrukelig]

But i will use it in access 2013 database.

[Luk3r]

There are plenty of demonstrations online for what you're trying to do. You must first create a procedure, whether that is a procedure to call or say, clicking a button, you must have a procedure. Something like this:

Private Sub Test()
    If TxtBox1.Value = TxtBox2.Value Then
        MsgBox "Equal"
    Else
        MsgBox "Not Equal"
    End If
End Sub

[Ubrukelig]

Thanks a lot!!! It realy helped me here! Wish you a Merry Christmas!!!