Query Not linking to Table fields

[FriQenstein]

Greetings all,



I have Queries galore... and they all work except one of them. The last one that I made just doesn't seem to want to work correctly no matter if I build it from scratch or copy, paste & edit it from an existing working Query.

Here is the scenario:
The Query is built using the proper table. In this instance table name = Bolt-Gun_Parts.
So my Form that uses a search function, like all of my other ones, calls the Bolt-Parts_SearchQ (Query).
My search criteria in the Query is as follows:

Like "*" & [Forms]![Bolt-Parts_SearchF]![Description] & "*"

Bolt-Parts_SearchF is the form used to do the search.

However, when I'm typing in the criteria in the Query for the search features, it doesn't want to pull information from the table accordingly. For instance, when you start typing the line above Like "*" & [Forms]![Bolt-Parts_SearchF]![Description]....
When you get to the [Forms] portion of the line, Access will pop up it's friendly little widow with the list of options to choose, as per normal.
Same thing when you get to the portion with [Bolt-Parts... the pop up list appears. However when I get to the [Description] portion, nothing happens. No popup and the Query is basically broken at this point.

I'm obviously missing something simple somewhere, but everything appears to be setup accordingly, even when I do a side-by-side comparison with my others that all work just fine.

Any assistance would be greatly appreciated.
Thanks.

[June7]

Are you saying there are no items listed for Bolt-Parts_SearchF?

An issue may be caused by fact Description is a reserved word http://allenbrowne.com/AppIssueBadWord.html#D. Should avoid using reserved words as names for anything.

Also should not use punctuation/special characters (underscore only exception) in naming convention.

Don't depend on the Expression Builder (I don't), just type out the expression you want and see what happens.

[FriQenstein]

I think I fixed it. It appears to be functioning now, however I had to actually set the Control Source in the properties window for each field whereas in all of my other search queries the control source was null and it pulled everything from the search form, passed it to the query then output it to the Report.

It's definitely strange that this one particular query is acting different from all the others.

As for the naming convention, I understand what you mean. I had some issues earlier on so I resulted in using dashes and underscores which appear to be OK when working with everything.

Thanks.

[June7]

Dash is a special character (minus sign) and therefore can cause issues if don't use [ ] to enclose object names. Again, better to not use.