How do I make my field inputs stay when I make a new record??

[gunwax]

To whom it may concern:

I have a form with multiple field inputs (about 50). Each time I go to create a new record, it makes all of them blank again. I know how to program one field to update at a time, but it won't update all fields. Does anyone know what to do to make multiple fields update all at once when a new record is created???

HELP PLEASE!

Gunwax

 

[Rob.Mills]

You could setup a query that would copy the existing record into a new one and then get the record ID of the new record and move to that ID.