Find & Replace Command Button

B

Bandit

In Access 2007 Find & Replace Command Button when opened has the following
options:

Look In with a drop down box to choose where to look;

Match with a drop down box to choose where to search;

And a search box with the following options: All, up or down.

I need to be able to let the user search for a specific item in the
database. I am working on the Allenbrowne search form but until I get that
right I need something that can be put into place now for the other users.
My question: Is there a way to open the Find & Replace command button and
have it default to a specific choice in each of the three choice boxes, i.e
Look in a certain table; Match any part of the field;
and search all?

Basically I want the user to look only in the areas that are specified
without them having to make the choices that the Find & Replace command give
them. Again, I want a really nice and functional search form where the user
does his input but I need something for the users to use now until I can get
the search form working correctly. I have been trying the allenbrowne search
code but I am missing something in it so it will take me some more time to
figure it out.

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top