Code not working, to get condition value

I

Irshad Alam

The following code is not working

Private Sub Label24_Click()
IIf(Me.PostDate.Value Between Me.RecDate.Value And Me.DespDate.Value,
Me.PStatus = "PostAll", Me.PStatus = "PostLater")
End Sub

Fields DataType are : PostDate, RecDate and DespDate are Date Field with
dd-mm-yyyy format. amd PStatus is a text field.

Please advise me, how to correct this

Also, please advise, if ever i find the same situation for Numeric field to
check like inbetween two number, how to deal with.

Regards.

Irshad.
 
D

Dennis

Try using if instead of iif in this way instead

If Me.PostDate Between Me.RecDate And Me.DespDate Then
Me.PStatus = "PostAll"
Else
Me.PStatus = "PostLater"
End if
 
O

Ofer

Try this

Private Sub Label24_Click()
If Me.PostDate >= Me.RecDate And Me.PostDate < = Me.DespDate Then
Me.PStatus = "PostAll"
Else
Me.PStatus = "PostLater"
End If
End Sub
===========================================
Or
Private Sub Label24_Click()
Me.PStatus = IIf (Me.PostDate >= Me.RecDate And Me.PostDate < =
Me.DespDate, "PostAll" ,"PostLater")
End Sub
 
Top