load blank subform

[slimjen]

All, using 2010. I have a search form(unbound) with 4 unbound txt boxes to filter a subform. When I load the form; It loads all the records. I don’t want this. How can I load with no records showing. Also; I have a clear button that clears the txt boxes to start another search. But when I clear; the last search record remains. I want to reset it back to not records. I tried removing the recordsource and or the sourceobject and I get errors or #name?. In addition; I have other subforms linked to the main subform and they all clear when clicking the clear button. Pls help.

[hapm]

Set the filter to False will filter all records.

[slimjen]

I set the filter in the property of subform to false then tried true; both ways didn’t clear the form. Does the cycle do anything?

[hapm]

Did you set it to "False" or to False? perhaps try something like True = False

[slimjen]

not working??

[hapm]

Then add a filter that checks the id field to be 0 or better NULL: ID IS NULL
This always work, but be sure to set FilterOnLoad to true as well

[slimjen]

Ok on the filter on load to true but do I create an event procedure? How??

[hapm]

Its a property of your form and should work without any event procedure.

[slimjen]

Great it worked! One thing; would it be too much to ask how do I make the filtered records unload on clear the unbound text boxes??

[hapm]

Simply set the filter back to ID IS NULL when clearing the textboxes

[slimjen]

This is not working when trying to clear the subform.

[hapm]

Show the code please.

[slimjen]

 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

It clears everything but the subform.

[hapm]

Well, you don't set the sub forms filter anywhere do you?

[slimjen]

Sorry, I don't know what you mean. The subform remains populated with the last filter