ADO and Adding records

[Valley Boy]

I am trying to add a new record to a database when a form loads. I have five text boxes linked to a database. Names and address will go into the database, and everytime I load the form it is showing the last record in the database, I need the text boxes to be blank show the users of my system can just input thier details and just press a button to add the records to the database. At the moment you have to press the command button before and after inputting detials to get this to work.
Can anyone PLEASE help me.

THANX IN ADVANCE

[darylcollins@op2.co.uk]

On form_load use the add record method:-

recordset.addnew

Hope this works

[Rohan_Powle]

Dear Friend,
try this code either on from_Load or Form_Activate Event

recordset.AddNew

----------------------

Such Type of manipulating codes r mostly given on the Activate event of the form......Because the recordset & such other entities get properly initiallised till this event fires...



-- Love Rohan