Cmd button open form type based on the field value (1 Viewer)

[Nancythomas]

Hello Everyone

I have a search form where I enter a date range and get a list of all files within a give date.

I have created a cmd button to open form1 or form2 based on the information / data in the above row (results)

I would like the system to do the following:

Private Sub cmdSrchAVLOG_Click()

If Field1.Value = "Availability" Then
''DoCmd.OpenForm "Form1"

If Field2.Value = "NOT Availability" Then
''DoCmd.OpenForm "FORM2"

End If
End Sub

This does not work. Can you please help

 

[JHB]

You've a quotes before the DoCmd, (remove it)!

[B][COLOR=Red]''[/COLOR][/B]DoCmd.OpenForm "Form1"

 

[pbaldy]

You also have two If statements but only one End If, so the code won't compile.