Queries Like Operator-Multiple Choices

[deepakg27]

Hi Guys,



I have made a query where based on multiple choices table is being refined on the fly. Everything seems working fine and for most of the part it does.

Problem being faced is, I have a table tblParties and tblChallan (tblChallan has the PartyID_FK), which is being used to link the two tables. Now when I search for results based on Like "*" & [Forms]![frmFindChallans]![PartyName] following command results are all Ok, but supposedly the partyID is 6 it gives result for 16, 26,36, 46,56, 66 and so on.

I tried removing the Like operator from the command also but in that case what happens is we must enter party name to get any results as it demands an exact match. What I need to do is, if the field is left blank results for all the parties matching the other criteria should popup, if any one party is selected then results matching only to that party (Exact) should popup.

PartyID_FK is storing valus in numbers in table tblChallan
PartyName is a field in tblParty with PartyID (as unique key)
ROW SOURCE on Form frmFindChallans - SELECT [tblParties].[BuyerID_PK], [tblParties].[PartyName] FROM tblParties ORDER BY [PartyName];

Hope I have been able to explain my problem. Looking forward to your help.
Regards
Deepak Gupta

[June7]

This is a dynamic parameterized query? I never use them. I use VBA to build criteria and apply to form or report when opening.

But try:

Like Nz([Forms]![frmFindChallans]![PartyName], "*")

[orange]

Are you using lookup fields in your table?
Perhaps you could provide a screenshot of your table designs and some sample data.
Good luck with your project.

[deepakg27]

Thanks June, the command worked Perfectly.

Regards
Deepak Gupta