search via user input on form

[TheRafterMan]

So under each field in my report there are records, and depending on which
field, there are some without records. Here is an example:
--------------------------------------------------------
NAME DIVISION Y/N

John Smith one Yes

Jane Doe two No

Jane Smith four Yes

Jack Johnson two -

--------------------------------------------------------

Using the example above in a form, how can I add a command
button, that when clicked (I guess one for each field/column), can allow a
user to
enter part or all of the criteria for the search. So if I somehow added
this button and a prompt
came up, and I entered "two" for the division name, everyone who was in
division "two" would show up and nothing else. How would I be able to do
that? Thanks in advance!

 

[Allen Browne]

Couple of options. See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

Alternatively, you could use this one which does not require to write any
code:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html

 

[TheRafterMan]

Do you have anything for Access 2003?

Couple of options. See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

Alternatively, you could use this one which does not require to write any
code:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html

 

[Douglas J. Steele]

Did you try them? Both of Allen's samples should work with Access 2003.

If you did and they didn't work, what problem did you have?

 

[TheRafterMan]

omg works, amazing, AMAZING. idk how to put that checkmark to say you guys
were right so let me know if it somehow helps your rating or something.

 

[Douglas J. Steele]

Glad you got it working.

I wouldn't worry about the checkmarking: neither Allen nor I worry about
that sort of thing.

 

[Allen Browne]

Agreed, Doug.

But we always enjoy knowing that you got it working, so thanks for that
RafterMan. Hope it helps you become productive in Access.