I have a Form with a Query record source and all is fine
adding an attachment field to the Query and then opening the form works fine but running a filter on the form i get.
"search key was not found in any records"
I've debugged it down to:
I have two of my fields in the Query with a "Last" option in the Totals, if i remove the Totals line in the Query i can filter it with an attachment field in the Query..but if there is an attachment field with its Total line set to "Expression" i get the error. when i add the attachment field it automatically adds the "Expression" to the Totals line...any way to get around it?
Any solution to this?

"search key was not found in any records"
I've debugged it down to:
I have two of my fields in the Query with a "Last" option in the Totals, if i remove the Totals line in the Query i can filter it with an attachment field in the Query..but if there is an attachment field with its Total line set to "Expression" i get the error. when i add the attachment field it automatically adds the "Expression" to the Totals line...any way to get around it?
Any solution to this?