Clearing fields in a record 1

[NWTrust]

I want to be able to clear all fields in a record displayed in a form, ready for insertion of new data. Deleting the record is not possible as the record is linked to a record in another table and I wish to retain the link. I know I can do it by deleting each individual field but as there are over a dozen fields I'm hoping there is a quick and easy way of achieving this. Any help would be greatly appreciated.

 

[randy700]

Something like this?

Dim ctl As Control
For Each ctl in Me
    If ctl.Type = acTextBox Then
        ctl.Value = ""
    End If
Next ctl

Randy