Pass selected test to a query

[detrie]

Access 2003

Hi All,

On my form I have a control txtCompany

I would like to select characters in the control and pass it to a select query

For example, if the txtCompany value is My Company Inc I would like to highlight “Comp” and pass it to a query where I expect to use Like “*” & [highlighted value] & “*”

My goal is to avoid typing values into an unbound field and using use Like “*” & [Unbound Field] & “*”

Thanks
Detrie