Lookup on a query with a wildcard

[RobertM]

Hello:

I need to have users enter the first few characters in a description and
then return all records that meet that criterion. What I would like is for
them to enter the values into a form and have that data used to run a query.
Here's the failing text I've placed into the query:

Like "Forms![FrmShortNameLookup]![Text0]*"

I'm not confident that I've done a decent job of explaining this. I hope
somene can help me out.

Robert

 

[KARL DEWEY]

Try this ---
Like [Forms]![FrmShortNameLookup]![Text0] & "*"

 

[John Spencer]

SO CLOSE.

Try

Like Forms![FrmShortNameLookup]![Text0] & "*"

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Amy Blankenship]

Hello:

I need to have users enter the first few characters in a description and
then return all records that meet that criterion. What I would like is for
them to enter the values into a form and have that data used to run a
query.
Here's the failing text I've placed into the query:

Like "Forms![FrmShortNameLookup]![Text0]*"

Try

Like Forms![FrmShortNameLookup]![Text0] & '*'