passing form textbox data to query

[tfoulkes]

I have a form with a text-box, then a query that uses the text from this text-box as a parameter to search on.
There is also a button which runs this query.

The SQL:

SELECT Get_Education.*, Get_Education.[Page Path]
FROM Get_Education
WHERE (((Get_Education.[Page Path]) Like [Forms]![page_hit_search_form]![wordInput].[Text]));

when I run this query on its own it asks me for the value and gets the results fine.

If I put a value in the form then run the query it is also fine.

But, I have a button on the form which runs the same query when clicked. If I use this it returns no results, but doesn't throw an error.

Any ideas?

TIA

Tim

 

[AJD10]

What is the Event Procedure behind the button? Do you have Docmd.RunSql or something else?

 

[tfoulkes]

I just used the button wizard to make a button that opens the query...