Prompt to allow partial data

[SDC]

Can I add a prompt in a parameter query that allows the user to enter a
partial value? For Example, if the parameter searches for a name, and there
is a name called "Monica", but the user enters "Mon", I need the search to
return "Monica" within the reaults. I do not want the user to be required to
enter exact values to return a data set.

 

[Duane Hookom]

Use a control (text box) on a form to allow your users to enter or select a
name. You can then set the criteria in the criteria like:
Like "*" & Forms!frmYourForm!txtName & "*"