make form create a new record

[Guest]

my custom form is changing the same record instead of creating a new one. how
do i tell the form to create a new record.

note: i am using multiple forms to create records to a table. i need each
form to update the table record information.

thanks.

 

[Ken Snell [MVP]]

Easiest way is to set the form's Data Entry property to Yes. That will cause
the form to go to a new record each time you open the form.

Alternatively, you can open the form and give an argument in the OpenForm
command:

DoCmd.OpenForm "FormName", , , , acFormAdd

 

[Guest]

i set the data entry property to yes on all forms. the forms open up blank
but when you type in info and click the next button to goto the next form,
access doesnt save the info to the appropriate row in the table. it appears
to be trying to re-write data to the 1st row record.

what next??

 

[Ken Snell [MVP]]

Not sure how you can type info into the form if it's blank, unless you mean
all the fields are empty (which, by the way, is what they should be if you
set the data entry property to Yes).

What you're describing seems to be a bigger problem than just this setting.
Can you post info about the form's Record Source (is it a table? a query?
what is the table's structure? or the SQL statement of the query?)? Are the
form's controls bound to the fields in the record source? What is the
"button" to go to the next form meaning to do?