Parameter Like Query Not Working (1 Viewer)

mreference · Oct 31, 2017

Hi, I have a totals query where a user can input a wildcard like query and works great - This is the criteria I use to capture the input.

Like "*" & [Enter Item Code] & "*"

Run the query, works as expected.

I have put this query into a continuous form, but I do not get the pop-up box requesting the Item Code, it just displays all the records.

Am I missing something or have some setting so the pop-up box gets ignored?

Minty · Oct 31, 2017

That sounds a bit odd. Does the saved query still prompts you if you run it on its own?

In fairness you would probably want to move the criteria to use a textbox in the form header of your continuous form, to save keep reopening it. So maybe now is the time to change it - Like "*" & Forms!YourFormName!YourControlName & "*"

mreference · Oct 31, 2017

It does work on its own in the query, I thought it was very odd too.

Good point on adding it to the form header.
Can you give me some instruction on how to get that working. I have added the text box, the wildcard should be added to the ItemCode field, so I have

Like "*" & Forms![frmCheckSupplierStock&Cost]![ItemCode]&"*"

But do not know how to include it on the form.

thanks for your help.

Minty · Oct 31, 2017

Just to check - ItemCode is an unbound control on your form header yes?

If it is go to your saved query and in the criteria box either paste the code above or click the builder, use it to build the criteria correctly.

arnelgp · Oct 31, 2017

Is it possible for you to rename the parameter.

Parameter Like Query Not Working (1 Viewer)

mreference

Registered User.

Minty

AWF VIP

mreference

Registered User.

Minty

AWF VIP

arnelgp

..forever waiting... waiting for jellybean!

Similar threads

Users who are viewing this thread