Creating a New Record with a data bound form

[Guest_imported]

I have a form with 10 textboxes that are bound to an access database. When I reach the last record, I want to be able to type in a new record for all the feilds I have displayed on the form.
I fill in one textbox with the information for that particular field; however as soon as I try to go to the next textbox to fill in the next feild, the first field is erased. So I end up with only being able to fill in one textbox and still unablecreating a compleate, new, all ten fields, record.
So my question:
How do you create a new record with a data bound form.

 

[tjfox]

1. if you reach the last record, issue the command

data1.recordset.addnew

2. then set the focus to the first textbox
3. type in the values for each text box
4. for the last text box, it's lost focus function should
contain the command

data1.recordset.update [sig][/sig]