IIf Statements with DoCmd

I have a MS sample database with a form named Task List that tracks daily task summary in table view. The first field reads either open if there is data for that record or new if data is null. When u click open, it opens the Task Detail form. Ive added a form to track Projects to this database and modified the Task List form to have a field "Task Type" to distinguish between type of work. I want modify the click open command to use an iif statement that opens either Project Details or Task details (Depending on the input) but it uses macros that i don't understand. I keep trying to code it in vba but i cant get it to work right. It seems simple but i cant get it.
I want the click on open to work like:
iif([task type]= "Project", DoCmd.openform ("Project Details"), DoCmd.openform ("Task Details")).
This generates a Complie Error: Expected: =
Can anybody help? Much Appreciated.

where did you made that code? inside microsoft visual basic ide or inside a textbox?

Sorry I fixed it. Code was off. I did type it in vb just had to change the syntax a bit. I appreciate your help. Just for viewing here is the code that does work:

If Forms![Task List]![Task Type] = "Project" Then
DoCmd.OpenForm ("Project List")
End If

I thought it should be that easy.

Marianne, thank you for your help. I figured out how to code the click open command for 1 work type option by the code:

If Forms![Task List]![Task Type] = "Project" Then
DoCmd.OpenForm ("Project List")
End If.

Works like a charm. I have two more different work type, "Trouble Response" and "Task", that I would like to have added to this code to open their work details form accordingly. All I did was edit the previous code to reflect the new options and the forms they should open as so:

If Forms![Task List]![Task Type] = "Project" Then
DoCmd.OpenForm ("Project List")
Else
If Forms![Task List]![Task Type] = "Trouble Response" Then
DoCmd.OpenForm ("Response List")
Else
If Forms![Task List]![Task Type] = "Task" Then
DoCmd.OpenForm ("Task List")
End If

The same simple evalutation, just 2 more added. I keep getting: Complie Error: Block If without End If. I tried messin with it but all with the same compile error result. Any suggestions?

Josh

Marianne, thank you for your help. I figured out how to code the click open command for 1 work type option by the code:

If Forms![Task List]![Task Type] = "Project" Then
DoCmd.OpenForm ("Project List")
End If.

Works like a charm. I have two more different work type, "Trouble Response" and "Task", that I would like to have added to this code to open their work details form accordingly. All I did was edit the previous code to reflect the new options and the forms they should open as so:

If Forms![Task List]![Task Type] = "Project" Then
DoCmd.OpenForm ("Project List")
Else
If Forms![Task List]![Task Type] = "Trouble Response" Then
DoCmd.OpenForm ("Response List")
Else
If Forms![Task List]![Task Type] = "Task" Then
DoCmd.OpenForm ("Task List")
End If

The same simple evalutation, just 2 more added. I keep getting: Complie Error: Block If without End If. I tried messin with it but all with the same compile error result. Any suggestions?

Change the red part:


To this

But I would really go for using a Select Case Statement:

Much cleaner and clearer this way.