Search Form

[Twillz]

I hope some one can help me. I want to make a search form that can search more than one table (I have 14 tables)and when the record is find its opens the form where the record is stored. The records would be search by their "order number". Thank you

 

[THWatson]

Twillz
Go to The Access Web

http://www.mvps.org

I note there are a couple of downloadable files.

In the Forms section ... "Adding a Search Form to a database"

In the Modules section ... "Search Wizard"

See if those help.

Tom

 

[jbento]

Here is a good site:

http://www.rogersaccesslibrary.com/

Also, I found a good search example database and you can download it here:

http://www.jerpat.org/sampledatabases.

There is a zip file called searchdb.zip inside.

Good luck and GOD bless,

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!