Run Report with Query and Comboboxes from Multiple Forms

[jlundbe2]

Hello!

I am working on an invoicing and receivables system and have one invoice report that is generated from one query (qryInvoiceMain). Now, the query is generated based on a control on a form. The issue arises as the criteria can be either from one form or another, only one of which is open when the report is ran. As such, I get prompted to enter in the ContractID from one form in a dialog box (which when I leave blank it runs the query from the or criteria which is open). I want the system to determine which form is open and then generate the query for the report based on the criteria from the open form. What is the best way to accomplish something like this?

Thanks for the help and let me know if its easier to post a sample db... I could mock something up.

Jason.

 

[maxmangion]

you can use the buildcriteria function

Dim strCriteria As String
strCriteria = BuildCriteria("FieldName", dbText, Me.TextboxName)
DoCmd.OpenReport "rptReportName", acViewPreview, , strCriteria