Search crisis...!

[Guest]

Hi

Im having serious problems setting up a form to search for data.

Basically, I would like other users (who have no knowledge of access) to
open a form and run a search that is purely for the use of viewing data - the
process needs to be as simple as possible. I have tried setting up a from
and using a combo-box to run the search, but I kept getting visual basic
errors.

So, alternatively I set up a form with a search button but Im naving
problems with this too. If I click on a field, and then hit the button I am
getting the message - 'You cant use find or replace now'. I suspect this is
because the field is blank but not sure how to solve this problem. This form
is pointed to a query.

Any ideas or suggestions would be appreciated, I thought this process would
be a lot simpler than its turning out to be!

Thanks

 

[Albert D. Kallal]

While looking at a form (in view mode), have you tried going:

records->filter->filter by form

The above turns your form into a dynamic search form.....

Also, have you tried the combo box wizard? Give that a try. In your data
form, add a combo box using the wizard..choose the option to find a
record....

There is also an example search form here:
http://www.datastrat.com/DataStrat2.html

http://www.mvps.org/access/forms/frm0045.htm

and, I have some ideas for a search form here:
http://www.members.shaw.ca/AlbertKallal/Search/index.html