If you used a WHERE Clause of " ", no records would be in the recordset.
You need ALL records to be in the record set - at least all if the relevant records. For example, you have a "Active/Inactive" field. So relevant records would include "Active". Then you would use "....WHERE CustStatus = 'Active'" and still be able to use the following.
What I have done in the past is to use the select/from. Then in the form on-load event, use something like
Example:
Form record source
Code:
SELECT Field1, Field2, Field3 FROM Table1
Form load event
Code:
Private Sub Form_Load()
Me.Filter = 1 = 2
Me.FilterOn = True
End Sub
Combo box afterupdate event:
Code:
Private Sub cbopro_AfterUpdate()
Me.Filter = "Macaddress = '" & Me.cbopro & "'"
Me.FilterOn = True
End Sub
To show all records using a button
Code:
Private Sub ShowAll_Click()
Me.Filter = ""
Me.FilterOn = False
End Sub
To re-hide all records using a button
Code:
Private Sub HideAll_Click()
Me.Filter = 1 = 2
Me.FilterOn = True
End Sub