Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Post Unanswered: Multiple Forms filter

    Hello all
    i need some ideas here
    i have a Simple Db consist of two tables "tbl_booking" & "tbl_visas" (common filed is "PPNo"
    i made to quires based on those tables "qry_booking" & "qry_visas" to select all columns..
    i made 3 forms
    form1 contain all fields from "qry_booking" - continues form
    form2 contain all fields from "qry_visas" - continues form
    form3 contain both forms "form1"&"form2" & "txtseach" (unbound text box) & "filter" (is a button)

    normally when i run form3 it shows all records in both tables !!

    Now i want to create a filter using values from the unbound text box to show only records where unbound text box is equal to PPNo in both forms 1&2

    appreciate your help

  2. #2
    Join Date
    Apr 2012
    Posts
    28
    What you have posted is already the idea. Good luck coding!

Posting Permissions

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