custom search form

[matthew nance]

i have included the "find record" command on several
forms. This is the command that i get when i use the
wizard when creating the command button. The problem is i
don't like the default settings that come up. can i
either change the default settings or design a custom form
that will allow me to search for keywords?

it would be really cool if the user could search using
multiple criteria (i.e. records that have a value in
certain fields and contain the keywords that the user
types. any help for this?

i'm using access 97 with windows 95
thanks,
matthew

 

[Arvin Meyer]

Have a look at this search form, which can be imported into your
application:

http://www.mvps.org/access/forms/frm0045.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[matthew nance]

that's way more complicated than what i want to do. i'll
take a look at the code and see if i can tailor it down.

i'm building a database for teachers to record students'
behavior infractions. these teachers start crying if they
see too many options. i need a form with one button.

thanks for giving me a starting place though. i'll see
what i can do with it today.

matthew

 

[Arvin Meyer]

Multiple criteria demands more complexity. For a simple search form, take a
look at the one on my website:

http://www.datastrat.com/Download2.html
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access