Usign a multi criteria search form as a select query

[craig1988]

Hi

I am having some problems with a select query that I am designing.

So basically I have a form with 10 text boxes. I also have a SELECT Query that uses the values of the text boxes as Criteria parameters.

I want to use the form as a search engine that I can use to search under one or more criteria.

There are a couple of scenarios to search under:


I want to search for an exact match: [Forms]![FSearchTransactions].[JPMCRefSearch] That seems to work fine.


I want to search for the end of a number: Like "*[Forms]![FSearchTransactions]![IBANSearch]" This does not work??
I want to search for part of name (lets say B SKY B, and I search for SKY): Like "*[Forms]![FSearchTransactions]![IBANSearch]*"

I am sure it is a silly syntax error but it is very frustrating.

Can anybody help me with these problems??

Regards
Craig

[ranman256]

make a table, in it is the list of queries you want to choose
EXACT
END o NUMBER
PART

for each of these values in the table, there would be a query
qsFindExact
qsFindEnd
qsFindPart
Each of these queries would be setup like you showed. full, a partial, or wildcard.

so the combo (of the type of search) would have

EXACT	qsFindExact
END o NUMBER	qsFindEnd
PART	qsFindPart

User picks the search out of the combo
fills in the search text box
runs search
the run button event would run the query in the combo box.