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