if then

[reyn240]

I am using the following code to get a mesagebox to open up.

If TC >= ([Forms]![frmpowderedwhites]![ColiformUpper]) Then
 '   MsgBox "COLIFORM TEST HAS NOT MET THE REQUIRED SPECIFICATIONS. PLEASE RETEST TO INSURE THE RESULTS ARE ACCURATE", vbOKOnly

. the problem I am having is that no matter what value I enter into the field the message box opens up. I only want it to open up if the value is greater that the ColiFormUpper field. Any suggestions would be greatly appreciated.

[orange]

Show us more code.
What is TC?
What is ColiFormUpper (number, text??)
The ' at the beginning of the msgbox line makes it a comment???

[reyn240]

The TC is the name of the field where the value us entered into. ColiFormUpper is the field containing the value that TC is compared to. Both are number fields. The ' is not in my code. I copied the code I put in the post from my documentation.

[orange]

Try putting this before your IF

Debug.print "TC is: " & TC & " and ColiFormUpper is : " & Forms!frmpowderedwhites!ColiformUpper

Then see what the values are in your immediate window.

[qa12dx]

If TC >= ([Forms]![frmpowderedwhites]![ColiformUpper])...

. I only want it to open up if the value is greater that the ColiFormUpper field. Any suggestions would be greatly appreciated.

right now it is greater than or equal to in ur code. i tried one with a date field, works for me;

If (Forms!Form1!tc > Date) Then
Beep
MsgBox "blah bhal", vbInformation, "gusta good"
End If

[Amerlitong]

The TC is the name of the field where the value us entered into. ColiFormUpper is the field containing the value that TC is compared to. Both are number fields. The ' is not in my code. I copied the code I put in the post from my documentation.

try to use ME. object reference(if that field its in the same form)---> ME.TC as u said this is a field...
when i see the code im thinking TC is a variable...

make it habit to use ME reference

Cheers

[Missinglinq]

Is TC a Variable, as has been suggested, or a Control on the currently opened Form?

Is ColiformUpper a Control on the same Form?

Linq ;0)>