Access Search Seminar

Access Search Template

Thank you Alex for the reference to the Seminar and Template. Currently I don't have the funds to purchase those. I guess I will just create two new forms and queries and go from there.

Regards,
Mark

Search Form 2.0

Mark
Check Search tech videos for search forms. There is couple of them. Also, give us more information perhaps we can help.

The Search Form 2.0 Extended video is exactly what I am looking for. Thank you Alex. My issue now is that the record source of the form is using 4 tables.

This is the SQL of the record souce.

SELECT Customer_PO_Details.*, Part_Number.*, CUSTOMER.CUST_NAME, Customer_PO.*, Customer_PO.Cust_Po_Closed
FROM CUSTOMER RIGHT JOIN ((Customer_PO_Details LEFT JOIN Part_Number ON Customer_PO_Details.[PO_Part_No] = Part_Number.[Part_Number]) LEFT JOIN Customer_PO ON Customer_PO_Details.[PurchaseOrder_ID] = Customer_PO.[PurchaseOrder_ID]) ON CUSTOMER.[CUST_CODE] = Customer_PO.[Cust_Code]
WHERE (((Customer_PO_Details.PO_Part_Quantity)>0) AND ((Customer_PO_Details.PO_Schedule_Marker)=Yes))
ORDER BY Customer_PO_Details.PO_Part_DueDate, Customer_PO_Details.PO_Part_No, Customer_PO_Details.[PO_Record_ No];

Is there a way that I can put this in the Private Sub RequeryForm and replace SQL = "SELECT * FROM Customer_PO_Details"

Regards,
Mark

I have an update. Since I have not been able to use the extended video's instructions, I was able to create a query and use a check box to filter my results. I would really like to not have to use a query if possible. I would like a combo box to choose my filter. I am not good with SQL at all and since this form uses 4 tables I am lost with being able to add the SQL code from the record source to the code from the Extended video. Is it possible to use the SQL from the record source of my form that I posted last night to this code that Richard created?

Regards,
Mark