Create a search engine via form.

[SKelly]

I would like to know how to make a form that will use many fields to search
through my main database.
Example: I what it to search Last Name, First Name and Account Type to only
put up the file or files that match all 3 criteria’s.

 

[Gina Whipp]

Susan,

Have a look at... http://allenbrowne.com/ser-62.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[SKelly]

I went to the website. That is what I am trying to do, but I do not know how
to.

 

[Tom Wickerath]

Hi Susan,

Perhaps this sample will be useful to you:

http://www.accessmvp.com/TWickerath/downloads/customdialogbox.zip

More advanced forms of QBF, where one is creating the WHERE clause of a SQL
statement in VBA code, can be found here:

http://www.accessmvp.com/TWickerath/downloads/elements.zip

http://www.accessmvp.com/TWickerath/downloads/Chap08QBF.zip

http://www.seattleaccess.org/downloads.htm
See the download "Query By Form"
Tom Wickerath, February 12, 2008


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

: 4/6/2009

I went to the website. That is what I am trying to do, but I do not know how
to.

Susan Kelly
__________________________________________

: 3/13/2009

Susan,

Have a look at... http://allenbrowne.com/ser-62.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
__________________________________________

: 3/13/2009

I would like to know how to make a form that will use many fields to search
through my main database.
Example: I what it to search Last Name, First Name and Account Type to only
put up the file or files that match all 3 criteria’s.