Passing parameter to query

  • Thread starter Thread starter enforcer47
  • Start date Start date
E

enforcer47

I created a custom form for a parameter query using the
[Forms]![Form Name]![Control Name]reference. This worked
well. Now I want to incorporate the like operator to allow
the person to query the database using combinations of
letters not exact names. I have been able to set the query
up and it works without a custom box. How can I combine
reference the custom form I created and use the like
operator.
 
Use:
Like "*" & [Forms]![Form Name]![Control Name] & "*"
OR
Like [Forms]![Form Name]![Control Name] & "*"
 
Back
Top