search via user input on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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?
 
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.
 
Glad you got it working.

I wouldn't worry about the checkmarking: neither Allen nor I worry about
that sort of thing.
 
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.
 
Back
Top