I tried following instruction on Microsoft website to construct a QBF:

https://learn.microsoft.com/en-us/office/troubleshoot/access/use-query-form-qbf-technique

I think I am having trouble with step 5:

Create the following new query that is based on the Orders table, and then save it as QBF_Query:

It says to provide criteria with OR in one line so it doesn't separate, but it in fact does separate after save. And with this criteria applied to six fields it complicates the query a lot. Yields no results.

Is there a better process to do this? Or better explanation of the QBF process somewhere?

CodePudding user response：

JK!! I forgot that I changed the record source of the form to the query while trying another way. After clearing the record source it works as intended.

CodePudding user response：

To the vote down, please explain how this post shows no research effort with a quote from another page with a link. Further, trying to research QBF is not quite as clear and fruitful as researching how to deal with type mismatch or "insert more common terminology here" but thanks