Concatenation problem 3

[Moss100]

Hello,

I have added to the end of this concatenation, but can not get it working. I think I have an error after the last AND statement - can anyone help? Thank you Mark

Me.Filter = "[Inv_Invoice_Dated] BETWEEN #" & DatStart & "# AND #" & DatEnd & "# AND [Number_Value]<> true AND [Inv_Pman_Lan_ID_WorkAt_Link] = cbo_Landlord_Select"

 

[OzFoxy]

Hi Moss100, try this:
....... = '" & Me!cbo_Landlord_Select & "'"

 

[dhookom]

OzFoxy’s reply is probably spot on unless the last field is numeric. The code would be:
AND [Inv_Pman_Lan_ID_WorkAt_Link] = " & Me.cbo_Landlord_Select

 

[strongm]

Something like

Me.Filter = "[Inv_Invoice_Dated] BETWEEN #" & DatStart & "# AND #" & DatEnd & "# AND [Number_Value]<> true AND [Inv_Pman_Lan_ID_WorkAt_Link] = " & cbo_Landlord_Select

depending on datatype of Inv_Pman_Lan_ID_WorkAt_Link

<fx: edit> Oops. Created this about 2 mins after the OP, and then forgot to actually post it. So it is pretty similar to other replies you already have

 

[Andrzejek]

Try something like this:

strF = "Inv_Invoice_Dated BETWEEN #" & DatStart & "# AND #" & DatEnd & "# "
strF = strF & " AND Number_Value <> true "
strF = strF & " AND Inv_Pman_Lan_ID_WorkAt_Link = " & cbo_Landlord_Select

Debug.Print strF

Me.Filter = strF

 

[Moss100]

Thank you all very much for your help - spot on