IF Statement Question

D

DS

I have an If Statement that dosent seem to be working. What I want to
do is this:

If the ItemType field on SalesDetails Form is "Main"
Them you open the SalesMod form as long as the SalesMod form has info in
it, if it doesn't or is empty or Null then you open the ModNotice Form

Also if the ItemType on the SalesDetails Form is "Mod"
Then you open the ModNotice222 Form



Private Sub Command20_Click()
If Forms!Sales.SalesDetails!ItemType = "Main" Then
DoCmd.OpenForm "SalesMods", acNormal, "", "", , acNormal
Forms!SalesMods!Text2 = Forms!Sales.SalesDetails!LineID
ElseIf Forms!Sales.SalesDetails!ItemType = "Mod" Then
DoCmd.OpenForm "ModNotice222"
ElseIf IsNull(Forms!SalesMods!ListModCat) Then
DoCmd.OpenForm "ModNotice"

End If

Any Help appreciated, Thanks
DS
 
Top