Include Wildcard Option within Form

[paulS30berks]

This may well be a simple question.

I have set up a Form to report Client acitivity by department Code for a given month. Users have the option within the form of selecting a Department Code.

These department codes are derived from a department Code Table and set accordingly within my Row Source properties.

If I wanted to select multiple departments for a particular report. how can i allow for wildcard entries i.e if several department code begin with letters OD*?

Thanks

Paul

 

[FoFa]

Typically you convert your crtieria to LIKE from =. Then the wildcard character would be accounted for.