Search Form in ADP

[T.J. Bernard]

I built a nice Search form in my MS Access version of my
database. It appears the same as the data-entry screen,
and the users can enter values into any or all of the
fields and select to Search by "And" or "Or". The code
built and MS Access Query on the fly by reading through
each text box to determined what was entered and building
the correct SQL Where string.

I am not sure how to set this up with my .ADP file. I
have tried creating different Stored Procs and nothing
seems to be able to duplicate this functionality in my ADP.

If anyone has any ideas or sample ADP files I can look at
let me know.

Thank you,

T.J.

 

[J. Clay]

This functionality is built in by using Filter By Form in an .mdb and Server
Filter By Form in an .adp. I have the same thing set up using Server Filter
By Form in a couple of apps and place a "Select Item" button to make the
main form go to the particular item found in the search.

HTH,
J. Clay