-
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
-
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
