If statement problem

[fatboy95]

I want to say thanks for all the help I have recieved from here. This is the best site I have seen of this kind!

My statement needs to work basically like this:

If order is not null then
if status is = "FMC"
MsgBox "You still have an order!"
end if
else
msgbox "FMC is now selected"
end if

The biggest problem I have is writing the correct line for If order is not null part. I can't get it to work. Also, I need status to stay what its original selection was if the order is not null.

Again, thanks for all the help.

 

[Treason]

If Not IsNull([Order]) then
     If Status = "FMC" Then
         msgbox "You still have an order."
     Else
         msgbox "FMC is now selected"
     End If
End If

It is easier if you Close every If Statement before you finish it. Also Tab over every time you start a new if. That just makes it easier to read.

 

[fatboy95]

I am pretty sure I tried that but will give it a shot again. thanks