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,
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,