How to use textbox data in an ACCESS form in an ACCESS query

[spearssc]

I have a form named PendingActionSearch and a textbox named: searchname. I need to use the data entered in the textbox in a query.

I've done this a while ago but I cannot remember the syntax. I know it's something link
Forms!PendingActionSearch.searchname
but I cannot get it to work.

You help is greatly appreciated.
spearssc

 

[PHV]

Provided that PendingActionSearch is an open mainform, in the criteria cell of the relevant field in query grid:
Like [Forms]![PendingActionSearch]![searchname] & '*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[spearssc]

I was close....

It works perfectly.

Thanks for your assistance!

Each One Teach One for the advancement of the "CRAFT"!