I need help to write the code to filter a Recordset called Data1 and a Field called AWEIGHT, when loading a form. I tried the following and it does not work. After the form is opened I only want to be able to search the filtered records. An example would be nice.
Private Sub Form_Load()
Data1.Recordset.Filter = "AWEIGHT > 0"