Wildcard search from a displayed dataset

[grinder332518]

My Form accesses a query to return a dataset from 2 tables.
There are almost 1000 rows returned, and I have the usual navigation buttons along the bottom.
So if I want to retrieve a row from the middle of the dataset, it takes quite some time to get to it, using these buttons.
I would like the ability to enter a wildcard search in one of the key fields.
I know I can use a parameter query like “Like "*" & [Search text] & "*"”,
but I don’t think this syntax will work in my scenario.

Perhaps a popup window would be displayed with the matches, and the user could then select the row required, and control then returned to the main Form, with all the other fields populated ?

Is this possible in Access 2003 ?
I have only had basic training, but nothing like this !
Many thanks in anticipation.

 

[vbaInet]

This would meet your need. Have a look:

http://www.access-programmers.co.uk/forums/showthread.php?t=189693&highlight=search+box

 

[grinder332518]

Thanks vbaInet : I'll check it out.

 

[vbaInet]

You're welcome. Post back if you need something explained.