| re: Search Criteria for empty data
mar10 wrote:[color=blue]
> I have a query that searches a name-address database for names entered
> into a form.
>
> I allow the user to enter parts of first name, last name and phone
> number. The criteria I'm using is
>
> Like ([Forms]![formSearch]![Phone] & "*")
>
> However if there isn't a phone number entered in the database I
> don't find the select individual.
>
> How can I change my criteria to allow for empty data?
>
> Is it possible?
>
> Thanks so much
>[/color]
or is null?
--
1f u c4n r34d th1s u r34lly
n33d t0 g37 l41d
| 
