Fields

[Abdulaym]

Hi, I have two fields, I.e. FieldA and FieldB and in which Field B contain a value in it while FieldA is empty.



If the value enter in Field A is greater than the value in FieldB then FieldA should not accept the value.

Thanks for your usual assistance

[Bob Fitz]

Use a form for your data entry.
Use the Form's Before update event, which can be cancelled, to validate the data being entered.
EDITED
Use code something like:

Private Sub Form_BeforeUpdate(Cancel As Integer)    If Not Me.FieldA < Me.FieldB Then
        Cancel = True
        MsgBox "FieldA must be smaller than FieldB"
    End If
End Sub

Post back if you need more help.

[Abdulaym]

Good day sir, thanks for your response

There is a pop-up message that FieldA must be smaller than FieldB, but the value subtract from FieldB by getting a negative value. If the value is bigger the value should not enter FieldA. Thanks I really Appreciate your effort sir

[Bob Fitz]

..... but the value subtract from FieldB by getting a negative value. If the value is bigger the value should not enter FieldA......

I don't understand what that means.
As a guess, try this:

Private Sub Form_BeforeUpdate(Cancel As Integer)    If Not Me.FieldA < Me.FieldB Then
        Me.FieldA = Null
        Cancel = True
        MsgBox "FieldA must be smaller than FieldB"
    End If
End Sub

[Welshgasman]

Good day sir, thanks for your response

There is a pop-up message that FieldA must be smaller than FieldB, but the value subtract from FieldB by getting a negative value. If the value is bigger the value should not enter FieldA. Thanks I really Appreciate your effort sir

You never said anything about subtraction?
Put the code in the BeforeUpdate of control A then.

[Abdulaym]

The first code work sir, I miss something which I just corrected. Thank you very much sir