Updating table without replacing records

[Guest]

Hi

How do I add a new record from a form without replacing a previous entry? I
don't want to use the arrows at the bottom of the form to increase the record
index.

Thanks!

 

[Alex White MCDBA MCSE]

Within the click event of a button

DoCmd.RunCommand acCmdRecordsGoToNew

 

[Guest]

I have inserted this into the VB module for the form that I am using, but it
doesn't seem to do anything. It doesn't give me an error message though. Any
idead what the problem could be?

 

[Guest]

Maybe a possible reason, is that Access doesn't know on which table the "Got
to New Record" command applies to. Where do I specify the table on which this
command must be applicable?

 

[Alex White MCDBA MCSE]

Hi,

It sounds like your form may not be bound to a recordset, as this action
should clear all the bound controls ready for you to insert new data.

can you post the "Record source" property for the form, and check the "Allow
Additions" property for the form is = yes

By the term bound, your controls on the form, should have a value in the
"Control Source" property.

 

[John Vinson]

Hi

How do I add a new record from a form without replacing a previous entry? I
don't want to use the arrows at the bottom of the form to increase the record
index.

Thanks!

Check the Form's Cycle property. By default it goes to a new record
when you have entered all of the fields in the current record; perhaps
the Cycle property has somehow been changed to "same record".

Normally, no code or any special actions are required to go to the new
record! Are you tabbing through the controls, or mouse-clicking into
them? How are you indicating to Access that the record has been
completely entered?

John W. Vinson[MVP]