Help with Search Form

L

lushh

hi guys... i am currently working on a search form for my database.. here's
how my form looks like:

http://i114.photobucket.com/albums/n258/lushh_16/searchbyclientform.jpg

when the user will type in for example "EOT Corp." in the "Search for" field
and will choose "Company Name" in the "Search by" combo box, the database
will look for all the "EOT Corp." entries under the field of "Company Name"
in a table.

the results should be shown in another filled form like this:

http://i114.photobucket.com/albums/n258/lushh_16/employeeform-1.jpg

does anyone has a sample VBA code for this function? i've been searching for
it, but unfortunately i wasn't able to find what i was looking for. thank you
very much. all your replies would mean so much.
 
L

lushh via AccessMonster.com

thanks a lot.. i'll try to do that.. i'll just keep you posted... good day..

Allen said:
Take a look at this article:
Find as you type
at:
http://allenbrowne.com/AppFindAsUType.html

There is a sample database to download, and copy the module, text box and
combo into your database.
hi guys... i am currently working on a search form for my database..
here's
[quoted text clipped - 18 lines]
you
very much. all your replies would mean so much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top