venuspcs
Last Activity: Nov 8 '08, 10:49 AM
Joined: Nov 5 '08
Location:
-
Sure, but I must warn you I am an amateur with Access in every sense of the word....... -
Yes there are records that meet the criteria of the combo box selections.Leave a comment:
-
Still doesn't work....every time I click the Apply Filter button I get a single empty row in the recordset.
This is driving me bonkers.....Leave a comment:
-
Okay thanks for the tip but it isn't working for me.....here is a screen shot of the form. The Combobox items are named cboCompany, cboDriver, cboTruck and cboDate.
Here is the code I am using:
...Code:Private Sub btnFilter_Click() Dim strFString As String strFString = "[Company] = '" & Me![cboCompany] & "' And " & _Leave a comment:
-
Apply Filter based on Selection of ComboBox
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...
No activity results to display
Leave a comment: