Repeating dialog box (1 Viewer)

[Lanser]

When using the below query I get a dialog asking for the Retailer followed by a dialog asking for the retailer ref then a second or so pause before it asks again for the Retailer then the ref before finally completeing the query
Used to work as expected until I added the wildcard section to RetailerRef


SELECT tblComplaints.CompNoID, tblComplaints.compDate, tblRetailer.Retailer, tblComplaints.RetailerRef, tblComplaints.ComplaintID, tblComplaints.Store, tblComplaints.StatusID, tblComplaints.Cost, tblComplaints.Action, tblComplaints.Product, tblComplaints.UseBy, tblComplaints.KillDate, tblComplaints.DOK
FROM tblRetailer INNER JOIN tblComplaints ON tblRetailer.RetailerID = tblComplaints.RetailerID
WHERE (((tblRetailer.Retailer)=[Retailer:]) AND ((tblComplaints.RetailerRef) Like [Retailer ref:] & "*"));

 

[boblarson]

If you are using parameter prompts, I would really suggest moving to using an input form for input and then referring to that. But if you insist, then you need to use single quotes around your text data. So if RetailerRef is text it would need to be:

AND ((tblComplaints.RetailerRef) Like '" & [Retailer ref:] & "*'"));