I have 3 value boxes receiving their criteria from 3 list boxes. I would like the 3 value boxes to filter a report called "Branches" accordingly as it becomes opened in either preview or print view.
The 3 value boxes simply dictate city, license & dealer respectively, for particular branches within the "Branches" report.
I would like to use VBA exclusively for this procedure.
Thank you for any assistance offered.

The way to do this is simply to write an SQL statement based on the selections from the boxes, and then have that statement populate an variable that is a recordset.

Then in the "On Open" event of the report, set the recordsource to that recordset.

Me.RecordSource = rs.Name

where rs is the recordset created by the program creating the SQL.

Let me know if you get stuck on this.

John

Hi John,
I am finally addressing this issue. Not out of laziness or procrastination, but overwhelmed with other VBA issues. I just started learning....
Your suggestion worked great. I have a pop up form with 4 combo boxes that offer criteria to create a SQL statement for the Main forms recordsource.
The code is very simple, but I would like, at this point to have an "IF" statement to check if the criteria is valid.
I don't know how to approach this.
eg;
If so and so is ? Then
MsgBox "No records match selection"
Else
Forms.frmProjects.Form.RecordSource = .....
End If
Any suggestions would be great, otherwise, thank-you very much for your help on my last 2 requests, very usefull information for sure!
Have a great day!

if rs.RecordCount = 0 then
    msgBox "No records found!",vbInformation
Else
   ....your code
end if

Hi Edcaru,
Thank-you for that!
After looking into what you said, I agree, it should work, and yet, it doesn't?
What I've done is simply create a SQL with a pop up form & assign it to the recordsource of the form I want to "Filter". All this happens from the "Find" command button from the pop up form. All variables are private within the click event method of the command button.
Do I need to declare any public variables & assign any to the form I want to "Filter"
The recordcount is always showing the total number of records in the query, no matter what criteria is entered.
Any help would be appreciated & thanks again for your original response!

Are u using a parameter query to populate the form you want to filter.
You can use Form1.filter = "SELECT * FROM table1 WHERE field1 = " _
& Forms!frmPopUP!combo1
R u using a fully qualified reference?

Hi Edcaru,
I'll try to explain as coherently & concisely as possible.
SQL works fine, search works fine...except if there is a record that doesn't exist according to user entries into upto 5 comboboxes.
Out of curiosity, I created a field that holds recordcount.
No matter what criteria is entered (as long as it's valid), the recordcount field always shows the maximum records "80", which is the the original query.
I played around with my If statement eg; If rec.recordcount < 80 Then
...and the Message box will appear.
So...it appears that the problem (for whatever reason), is that even when a new record is formed(initially), the record count always shows 80?
I don't know what "clause" to stipulate in the IF Statement to ensure no non existent record will create a new form.
I still feel, what you said, If rec.recordcount = 0 Then... should work?
Either way Edcaru, Thanks again!