Can someone exsplain and show me why this code isnt working?

Private Sub cmdOnOrderReportButton_Click()
DoCmd.OpenReport Me.CboReports, acViewPreview, , "[BuyerDesc]='" & Me.CboPeople.Column(1) & "'"
Else IF
DoCmd.OpenReport Me.CboReports, acViewPreview, , "[null]='" & Me.CboPeople.Column(1) & "'"

End Sub

Thank you

Corey

What I'm trying to get it to do is show all the people that have a name within [BuyerDesc]

You have an "Else If," but no initial "If." Think what you would get from someone starting a conversation with you, starting with, " . . . otherwise I need to go to the . . ." You need the initial condition that the otherwise is in opposition to, otherwise there is no context.

You need to either supply the "If" condition on the line where you have "Else If," or remove the word "If."

You need to provide an "End If," unless you are writing a single-line "If" statement.

You have a field named "null"?!? (Try to [u]never</u> use keywords as entity names. The first time you forget to delimit the name, the environment will recognize the keyword (therefore not balking), but the behavior will be anything but what was intended.