ADO

[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

[Mark Sreeves]

Personally, I wouldn't bother linking the text boxes to the database but just execute an SQL "INSERT..." to add the data to the database.