access query question 1

[Awarmplace1]

How do i use the asterick in a query that is referencing a form in the criteria...I am trying to get the query to find and part of the information that i put into the form.....help!!!!!!

 

[tlbroadbent]

Here is one way to do the search.

Select col1, col2, col3, ..., colN
From table
Where colX Like "*" & [forms].[FrmName].[textname] & "*" Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.