Text Box Filter Question

[ShadeRF]

Is it possible to allow filter multiple items with a single text box? For instance: I want to allow them to filter by Invoice #. Is it possible to input multiple Invoice #'s into a single text box and return those Invoice #s? I don't really want to use a combo box.

[NTC]

well not really - perhaps is the best answer.... will the human separate those by a space, comma, semi colon? ...that's a rhetorical question about really how disciplined will your users actually be......

one can definitely manage with vba the parsing of their entry and create a dynamic sql string - but again the starting point has to be some structure to their input....you probably are best off using separate text boxes.....

one could make a parameter prompt in the query itself - - and try entering multiple values with an OR

Not sure it helps.

[ShadeRF]

Seperating with a comma would be no problem as this is actually their preferred method of entry.

[NTC]

perhaps I am cynical - but the human still is highly variable

this,that
this, that
this ,that

are all different.....you can use String commands to chop it up into separate words, trim out spaces at end, and then build an sql statement....will be tricky especially if one doesn't know how many words might be there....using string manipulation will need to find the commas,count spaces, etc etc..........

[ShadeRF]

The search field is only for numbers, which are typically 7 digits in length.