Option in Form

[azhar2006]

Hello all
I've put a check box (yes / no)
But when you open the form, this message appears

Private Sub Form_AfterUpdate()
If Me.Cach = "Yes" Then
Me.HASPa = Me.Text29
Me.AmountPa = Me.Text31


ElseIf Me.Cach = "no" Then
Me.HASPa = 0
Me.AmountPa = 0
End If
End Sub

[Missinglinq]

Since the Checkbox is tied to a Boolean Field, so you can't compare them to strings, like you've done, You can use True/False or 0/-1:

If Me.Cach = True Then
  Me.HASPa = Me.Text29
  Me.AmountPa = Me.Text31
ElseIf Me.Cach = False Then
  Me.HASPa = 0
  Me.AmountPa = 0
End If

I'd also put this in the Cach_AfterUpdate event, rather the the Form_AfterUpdate event.

Linq ;0)>

[June7]

First of all, a checkbox does not have text value so "Yes" or "no" will not work.

If Me.Cach = True

or

If Me.Cach = -1

or

If Me.Cach = False

or

If Me.Cach = 0

[azhar2006]

Thank you very much Miss and june
Very good
But the message still appears
But there are other database I have not found where (Cach)
Do not show me the error message
Only when I add (Cach)

[June7]

Do you have code in the form OnCurrent event? The error references that event.