Search Within Search

Results 1 to 2 of 2

Thread: Search Within Search

  1. #1
    Join Date
    Dec 1969

    Default Search Within Search

    How do you do a search within results?<BR>Which means to search within the results you got from the first search.<BR>I am using SQL for the search.<BR><BR> <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Rs.Filter

    You could try using the Filter method on the Recordset:<BR><BR>With rs<BR> .Filter = "[fieldname]= &#039;" & variablename & "&#039;"<BR>&#039;&#039; You can filter on multiple fields using AND and OR (but check out the rules on if you have any probs)<BR><BR><BR>End With<BR><BR>&#039;&#039; DO Further Stuff Here<BR><BR>rs.filter = adfilternone &#039;&#039; Turns Filter Off<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts