Finding specific records

[Guest]

Hi everyone,

Like to say what a great group this is and thanks for all the help in the
past.

However moving on here is my dilema today, I have a form that is based on a
query from several tables, this query can have hundres/thousands of records,
what I would like to do is do a search on a specific field and jump to that
records form, what I am thinking is along the lines of the record navigation
button for find but when I press the command button on my form it defaults to
the required field and parameters leaving the user to enter the search text
criteria.

MTIA

 

[Arvin Meyer [MVP]]

Have a look at Filter By Form (Records ... Filter ... Filter By Form). The
interface may be just what you are looking for. Once selected from the menu,
simply fill in any field and click on the Filter button (the funnel)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Yes that would do what I want , but is there a way to run 'filter by form and
apply filter' from code and again to remove filter

TIA

 

[Arvin Meyer [MVP]]

Sure:

DoCmd.RunCommand acCmdFilterByForm
DoCmd.RunCommand acCmdApplyFilterSort
Docmd.RunCommand acCmdRemoveFilterSort

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Hi,

But How would I get it to pause between 'filter by form' and 'apply filter'
so that the user can enter the required criteria

TIA

 

[Arvin Meyer [MVP]]

Opening Filter By Form pauses by itself. You would then enter your criteria
and push another button to apply the filter.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access