[AccessD] Searching Access

Rich,

Having some apps with similar needs...I typically create a search screen 
that allows the user to "mix/match" their search criteria...the form has 7 
or 8 fields the user might want to search...and can fill in partially or 
fully 1 or all fields.  A query is then run using these fields as criteria.  
The results are displayed in a subform...when the desired record is 
found...the actual form used to display all pertinent fields( and subforms) 
is launched using the PK of the record selected and only displays this 
record.

I'm not sure if this is the best approach...just my favorite and most 
reliable for this function I have found.  There are a few 'twists' to the 
approach...depending on how many records you are searching.  If you are 
interested...I can go into more detail...or put together a sample to send 
OffList.

Hope it helps...

Mark A. Matte

P.S...(just a little ACCESSD humor)...I was scared to use the word "unbound" 
to reference the search screen I described, because I know some of the 
discussions it might spawn...but anyway...


>From: "Lavsa, Rich" <Rich_Lavsa at pghcorning.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>,   <ACCESS-L at PEACH.EASE.LSOFT.COM>
>Subject: [AccessD] Searching Access
>Date: Tue, 13 Sep 2005 09:36:09 -0400
>
>Hello all,
>
>In the past I have jumped through some pretty big hoops to give my users
>the ability to search and jump to the record(s) that they are in need of
>getting to.
>
>Searching on a single form is easy enough through the Search, or QBF,
>but what about when you have subforms, or want the users to search
>through the entire database for something or have a memo field that is
>need of searching..
>
>Anyway, I was just wondering if I was missing the boat on the search
>capabilities of Access.  It is so labor intensive to give the users a
>searchable form so they can easily jump to the desired record, as I very
>rarely have a single independent form that does not have a subform or 2
>in it.
>
>Any tips, tricks, hints would be greatly appreciated.. Or pointers to
>any white papers, articles, tutorials.. Anything useful would be great
>as I've searched the archives and Google without much success..
>
>Thanks,
>Rich
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com