Asking for a date gives me a date range (concatenate)

[Ruegen]

DoCmd.OpenReport "rptTaxInvoicesCompany", acViewPreview, , "[TradingAsID]=" & Me.List0.Column(0) And "PaymentDateBanked1st = #" & Me.txtDateField & "#"



I keep getting data mismatch, clicking on a main form's listbox opens the records but I have an unbound textbox with short date format to open what I click in that list by the date in the unbound textbox.

data missmatch 13

I'm doing something wrong not sure what

P.s. not date range, incorrectly put in title

[ItsMe]

This kinda jumps out at me

"PaymentDateBanked1st

[Ruegen]

I tried it with "[PaymentDateBanked1st]=" and I still had the same error - I ended up putting [forms]![frmTaxInvoicesCompany]![txtDateField]and it works... but yes I would prefer the vba method

[ItsMe]

Hmm... thanks for posting the result

[Ruegen]

Hmm... thanks for posting the result

I'm wondering if it has to do with having the "is not null" in the query, perhaps removing that and putting it in the vba code as another and?