Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009

    Question Unanswered: Query by Form - form has subform

    I have an Expert Witness form with fields from the tblExpertWitness. Two related subforms on main form -- 1) witness strengths & weaknesses and 2) attorney comments. I have created a popup query form with unbound fields that looks like the main form. It works, but I don't know how to include search ability within the subforms, so that if, for example, one wants to search for any comments that say "don't use", only the expert witnesses matching that comment are returned by the query.

  2. #2
    Join Date
    May 2005
    I would build a Filter string dynamically and then apply it to the subform control. If you need more examples, there are literally thousands of similar examples out there via Google, and I'm quite sure there are many just on this forum alone. Give it a shot and let us know if/what more help you need.
    Me.Geek = True

Posting Permissions

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