Macro Problem.....PLEASE HELP !!!!!!

[marksparro]

Im trying to setup a form that has a blank text box with a search button next to it. I want to be able to type a search string into the text box, and then be able to click on the search button and have it search a table. If ANYONE knows what I need to do, PLEASE let me know.

 

[tlbroadbent]

Microsoft provides a sample database with versions 97 and 2000. It contains a query by form example.

Read this article to find how to install the Access 97 version.

http://www.microsoft.com/ACCESSDEV/Articles/Bapp97/Chapters/appa_1.htm

Download the Access 2000 version from

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bapp2000/html/mdbdownload.asp

Here are other links to review. They discuss query by form.

faq181-120

http://www.mvps.org/access/forms/frm0045.htm

http://www.mvps.org/access/forms/frm0001.htm

http://www.mvps.org/access/forms/frm0007.htm

http://www.mvps.org/access/queries/qry0003.htm

Query by form is a frequent topic in these forums. You should try a keyword search.
Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin