load blank subform

[hapm]

Then change the filter using the forms filter property or do a requery on the sub form, regarding wether you used the .Filter or some filter in the record source.

[slimjen]

I’ve tried all of what you suggested. It only clears the first field in the first column. The filter property of the subform is already set to filter to cust_id=null and filter on load set to yes. When I open the form; the subform doesn’t have records like I want but when a search is performed and after reset; all controls on the form clear but not the subform. Is there a way to reload the form as if opening when the database is closed since this seems to work?

Private Sub btnClear_Click()
  Dim ctl As Control
   Dim txtBx As TextBox
   For Each ctl In Me.Controls
      If ctl.ControlType = acTextBox Then
         Set txtBx = ctl
         If txtBx.Tag = "clr" Then
            txtBx.Value = Null
      End If
      End If
   Next ctl
' [Forms]![frmCustSrch]![sfrmCustSrch].[Form]![Cust_id] = Null
'Me.sfrmCustSrch.Requery
 [sfrmCustSrch].[Form]![cust_id] = Null
End Sub

[hapm]

what is the value of the filteron property? It should be set to true.

[slimjen]

Sorry for the delay. Iv'e done everthing suggested but still doesn't seem to work. when I put "[sfrmCustSrch].[Form]![cust_id] = Null", it only cleared the first field in the first record.