multiple criteria search page

I am using the following code to search for records in my database:

DoCmd.OpenForm "Form1", ac Normal, , "[Field1] Like '*" &Me.Text1 & "*"

This works for a single field, is there a way to write the search so that I
can incorporate multiple fields? Can I use "AND" so that the user can enter
several fields of information for the purpose of searching?

Thank you for any assistance.

LB


.

Relevant Pages

  • Re: Report / Sub-Report Problerm
    ... Thank you very much for your assistance. ... solved my problem and I am now able to deliver this database to my ... client with the functionality they have requested. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Importing from other application
    ... >> without going through all 10,174 lines in my database ... >> Thanks for any assistance! ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Data filter--No Records Found
    ... I have a data filter built into my database for users to search all records. ... Thank you in advance for any assistance. ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Pop up Problems
    ... when opening the pop up form all the comments ... I can email the database for an ... Any assistance would be most appreciated and thank you to all ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Option Buttons in VB.NET
    ... group boxes. ... single field in my database. ... Prev by Date: ...
    (microsoft.public.dotnet.general)