Apply Filter based on Selection of ComboBox

[venuspcs]

Okay I am using Access 2007 with several tables and several forms.

The main data is saved to table: Load_Records
There is a Form that updates that table named: Add New Loads To Database
There is another Form used for printing custom reports named: Generate Reports

The Generate Reports form automatically creates and populates a recordset by data binding to the Load_Records table. In the footer of this form there are three combo box's named: CompanySelect, DriverSelect and TruckSelect

The values of the combo box's are populated automatically from tables/columns named: Company!Company , Driver!Driver and Truck!Truck

What I want to do is have ALL THE RECORDS of Load_Records filtered automatically OnChange of any or all of these combo box's.

I have played around with DoCmd.ApplyFilt er but have had no success in getting it to work correctly.

[ADezii]

Sure, but I must warn you I am an amateur with Access in every sense of the word....

Here goes, venuspcs:

1. Make sure that the On Click() Event of the Apply Filter has [Event Procedure] as its setting.
2. Copy and Paste this exact code into the Click() Event of the Apply Filter Button. This code has been tested and is operational.
   

   Dim strFString As String
    
   strFString = "[Company] = '" & Me![cboCompany] & "' And " & _
                "[Driver] = '" & Me![cboDriver] & "' And " & _
                "[mmddyy] = '" & Me![cboDate] & "' And " & _
                "[Truck] = '" & Me![cboTruck] & "'"
    
   Me.Filter = strFString
   Me.FilterOn = True