Parameter Like Query Not Working

[mreference]

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]

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]

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]

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]

Is it possible for you to rename the parameter.