returning annals partially review value

i'm perplexing query operative takes values (sometimes only initial biased string) form control. problem i have wholly advantage annals full twine typed in.

i.e. surname box, i should means form gr, brings adult

green
grey
graham

but during donation it's bringing adult anything uless full hunt twine used.

there 4 hunt controls form question, wholly used query box filled in.

the query :

select tabcustomers.*,
       tabcustomers.customerforname namesearch,
       tabcustomers.customersurname surnamesearch,
       tabcustomers.customerdob dobsearch,
       tabcustomers.customerid membersearch
from tabcustomers
where iif([forms]![frmsearchcustomer]![searchmember] null
          ,true
          ,[forms]![frmsearchcustomer]![searchmember]=[customerid])=true
      iif([forms]![frmsearchcustomer].[searchfore] null
              ,true
              ,[forms]![frmsearchcustomer]![searchfore] [customerforname] & "*")=true
      iif([forms]![frmsearchcustomer]![searchlast] null
              ,true
              ,[forms]![frmsearchcustomer]![searchlast] [customersurname] & "*")=true
      iif([forms]![frmsearchcustomer]![searchdate] null
              ,true
              ,[forms]![frmsearchcustomer]![searchdate] [customerdob] & "*")=true;