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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ECHO in the right place? 0
It Says NO CURRENT RECORD 2
I figured out the issue thank you. 0
Referencing Subforms 1
DMax Problem 3
If Statement Not Working 2
IF Statement 5
Cant See Form 2

Top