I have a button to open a form that allows a user to look at orders based on the delivery date [DelDate] and the [Seller]. When it was just the delivery date, everything seemed to work well, but then I needed to add a specific seller and now every time I open the form it asks me to input the seller, but I don't know why... the information should already be there. I'm thinking that I don't have the syntax correct, but when I look it up it looks like how I already have it...
Code:
DoCmd.OpenForm "frmInvoiceNumbers", acNormal, , "[DelDate]>= #" & Me.comboMonth & "/" & Me.comboDay & "/" & Me.comboYear & "# AND [DelDate]<= #" & Me.comboToMonth & "/" & Me.comboToDay & "/" & Me.comboToYear & "# And [Seller] like '*Choice'"
Any thoughts?
Thanks in advance!