Clearing text boxes

[Harrild]

Ok you all know access dont u? When you go to add a new record to a form and all the text boxes clear and the autonumber (if u have one) increases by 1? Well i want to do a similar thing in VB for my database but i dont know how to do it. I would prefer DAO but ADO if it is neccessary.

ok i have used data1.recordset.addnew before and it was just too confusing for the user (i wrote the program and i found it confusing!) so anything that might help would be gladly appreciated....

Harrild

[Psyrus]

To clear all of the textboxes on the form you can do:

Public Sub Clear_Boxes()

'Iterate through the controls, if it's a textbox empty it

Dim aBox As Control

For Each aBox In Controls
If TypeOf aBox Is TextBox Then aBox = Empty
Next

End Sub