You might be surprised on difference between pure users and those that
design. Many users get into some type of designing because of availability
of Access and management thinking because it is in the Office Package anyone
can use it. I believe that any application in Access beyond simple forms
and reports really should be developed by someone with programming
experience. This is one of my pet peeves. But I digress
The point though is Access as a "programming" platform needs little pure
user support because the designer should be putting in the features that are
needed and letting the end user know about any "search modes" that are in
the solution.
There are however a few way that you can search for data. If the
designer has left the capabilities open to you.
If you have the Toolbar that shows the ZA then there are 3 Icons Filter
by Selection (with a Lightning bolt), Filter by Form (form ) and
Apply/Remove Filter
1. In a form you can go to a field and select the Filter by Selection
and it will only show you those records that match what is in the field
2. In a form you can use the Filter By Form to put in your own values in
a "Blank form" and then click the Apply Filter.
Another way is to create your own queries. But now you have started to
become a designer and not just a "user"
, and the designer probably has
denied this to you.
--
Craig Hornish
Visit weekly Access conferences
Tuesday, 11:00am-12:30pm (Eastern US)
Thursday, 3:30pm- 5:00pm (Eastern US)
http://community.compuserve.com/n/pfx/forum.aspx?webtag=ws-msdevapps
"Think outside the box, because anything is possible."
"How long it will take or whether it requires divine intervention is another
issue"