Code not working, to get condition value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
Back
Top