clear tab control with subforms

[Saphyre88]

Hi,

what is the best way to clear data from multiple subforms of a tab control at once ?

The tab control is updatable on a change of a list box. However, when a second listbox is updated, all the information should be cleared from all tabs. ???

Thanks

 

[Remou]

Cleared as in:
- a new record for data entry;
[tt] Docmd.GotoRecord ...[/tt]
- a blank screen;
[tt] Me.[Subform Control Name].FormAllowAdditions=False
Me.[Subform Control Name].Form.RecordSource = _
"Select * From tblTable Where 1=2"[/tt]
- or empty the current controls?
[tt] You will probably wish to add other control types
or perhaps use the tag property to mark controls
to test. You may also wish to test for several data
types.[/tt]

For Each ctl In Me.Controls
   If ctl.ControlType=acTextBox Then
     Me(ctl.Name) = Null 
   End If
Next