Re: Search Criteria

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 04/01/04 

Date: Thu, 01 Apr 2004 10:03:21 -0700

On Tue, 30 Mar 2004 10:11:11 -0800, "Help"
<anonymous@discussions.microsoft.com> wrote:

>Just to clarify my previous thread. I have three fields in my table, one %C and %H and %N. What I need is to place code behind a command button that would take the date entered into a texbox on a search for and look for records in database that has values for the any of the above fields.
>
>Thanks for the help

If you wish to clarify, please reply IN THE THREAD rather than
starting a new thread. "Help" is not that easy a term to Google, not
that most of the volunteers here have time to open up Google Groups to
try to find your previous thread!

No code is needed. Simply create a Query with a criterion

=[Forms]![NameOfForm]![NameOfControl]

under each of the three fields, on separate rows in the query grid so
it uses OR logic. Also, do NOT use % in fieldnames; Access *will* get
confused.

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public