Report criteria by Form

[MrAustin]

Hi all,

I am using the following code on a command button:

Private Sub cmdPrintTicket_Click()

    DoCmd.OpenReport "rptPrintTicket", acViewNormal, , "[tick_id] = " & Me.tick_id.Value

End Sub

But when I run the code, it prompts me for "cust_id" which is another field on the form, and in the Tickets table. Any ideas why it is doing this?