Hi all,

I've got a SQL query that I'm pulling from user's selections on a form. The string is built using:

theString = "select parcels.id, parcels.county_id, parcels.parcel_id, " & _
            "parcels.owner, parcels.address1, parcels.city " & _
            "from parcels " & _
            "where " & Me.FieldToSearch.Value & " like '*" & _
            Trim(Me.string) & "*'"

When I run the code the query evaluates to:

select parcels.id, parcels.county_id, parcels.parcel_id, parcels.owner, parcels.address1, parcels.city from parcels where Owner like '*se*'

I've tried this exact SQL statement in a query (the evaluated one) and it works and I get 2 records using my test data. But when I run the form -- and I've checked the value of the evaluated SQL statement and it's exactly this not to mention I cut and paste the evaluated statement in the query that gave me 2 records -- I get 0 records in the recordset.

Why would a SQL statement work as a query but the exact same one not work in a form? Why would I get 0 records in the recordset in the form whereas I get 2 records using the exact same SQL statement in my query?

Thanks for any help you can give.

Denise