Search box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have a search box like Google has.

Ex:
I enter the letter S and then everything start with letter S will pull out.

Type S in search box, then Sheila, Son, Somers.... will show.

Can I use parameter query to create a search box? If you think I can do
that, please show me the criteria.
 
You can use a combo box on a form. This type of functionality is not
available in a parameter prompt.

Unless you only want to show records where a field value begins with
specific characters. If that is the case, you can set your criteria to
something like:
Like [Enter First Characters] & "*"
 
Hi Duane,
Thank you so much for your replies. They work! (my both questions). You did
excellent job.

Duane Hookom said:
You can use a combo box on a form. This type of functionality is not
available in a parameter prompt.

Unless you only want to show records where a field value begins with
specific characters. If that is the case, you can set your criteria to
something like:
Like [Enter First Characters] & "*"

--
Duane Hookom
MS Access MVP

Chi said:
I would like to have a search box like Google has.

Ex:
I enter the letter S and then everything start with letter S will pull
out.

Type S in search box, then Sheila, Son, Somers.... will show.

Can I use parameter query to create a search box? If you think I can do
that, please show me the criteria.
Click to expand...
Click to expand...
 
Back
Top