Daryl Sawyer wrote:
I've got a simple "card catalog" system set up. We've got filing cabinets
full of reports filed by report number. I've got a simple, flat database
(report# is the key), a form for entering in data, a queary that shows the
records that still need to be printed (until I have this totally
implemented, I need to maintain the old, paper-based card file), and that's
about it.
The only thing I have left is to design a form that will enable the user to
search for a record by address (without having to muck about with the queary
interface--not a person to teach new tricks to).
You can use the search function available at the form, or the form
filter method.
For the first look to form navigator bar, most likely at the bottom of
your form. You will see an icon for binoculars, named 'Find Record' (
DO NOT confuse this with the icon for binoculars at the top of the form
), click the icon and the record search box opens. It is fairly self
explanatory.
For the second, again on the navigator bar click on the 'Form-Based
Filters' icon usually found third from the right ( it is picture of a
form with a funnel super-imposed over and slightly below it ). Click on
this and the conrols in your form all go blank, and a new toolbar opened
with three buttons on it ( Apply, Filter Navigator, Close) - you enter
data into any of the controls as you like, then select the Apply Filter
icon on the newly opened tool bat.
Spend a few minutes working with these and you find that you are done, now!
HTH
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
