How can I create a form that will allow the text entered to be entered into the criteria row for a Select Query? Can this be done?

What I want to do is type search criteria into a form field and have it be the search criteria of a query.

In your query you will need to reference the form and field.

Example On a Form Called [frmSearch] I have a field called [txtCriteria]. To use this field in the query I will add this line to the criteria row:

Forms.[frmSearch].[txtCriteria]

Thats all you need. Just remember once this is in the query you will need the form open or it will keep asking you for a value.

Good, I've got that working now, thanks.

How can I use an * for the wild card. When I enter an * the search comes up blank.

Try

Like "*|[Forms]![Form Name]![Field]|*"

There may be an easier "newer" way to do it - my knowledge is a bit dated, but I think this will work for you.

Cheers

Thanks, that worked to broaden the search. Both Darren and Travis's expressions worked. I have implemited them both.