Comparing user input with a table on click

[xpun]

Hey all

Im working on a project that requires me to check if the member number that is input in the form is equal to an existing member number.

The problem is that even if the member number is correct the error message pops up and says it doesn't exist.

am i referring to my fields correctly? there is a direct relationship set up between the two. membernum and mnum

Private Sub Command9_Click()
If Membernum <> Mnum Then
Dim x As Integer
x = MsgBox("Not an Existing Member", vbOKOnly, MemberError)
End If
End Sub

[pks00]

What is the field on the form and what is the table field?
What is Membernum and what is Mnum?

Have u confirmed that both fields have a value? Im assuming u are already populating one field

to confirm, simply place a msgbox before the check

msgbox "Membernum=" & Membernum
msgbox "Mnum=" & Mnum

if one is empty, u can always use DLOOKUP to check
eg

DLOOKUP("fieldname","tablename")

optionally add criteria and it returns null if no recs found

eg
If IsNull(DLOOKUP("fieldname","tablename","fieldname= '" & enteredvalue & "')) = True then
msgbox "not found"
end if

[xpun]

mnumber is the member number entered in on a separate form , mnum refers to the member on a transactions form

i tried those messaged boxes and Membernum (the field form the seperate table pops up blank

[xpun]

mnumber is the member number entered in on a separate form , mnum refers to the member on a transactions form

i tried those messaged boxes and Membernum (the field form the seperate table pops up blank

i forgot to mention that Mnum and membernum are in separate tables