Form to add new record

I feel this must be the most basic question, but I just can't figure it out.

I want to create a form that will allow me to add a new record to my database. I have designed the form and linked it all up to the data base, but when I open the form, the first record is displayed and I have to tab through all the records to the end of the table to get a new one. I don't want to do that, and I don't want to risk someone changing the existing records, so I want the form to zip straight to adding a new record, without giving the option of modifying the existing ones.

Please, just point me in the right direction.

Thanks

Vaughan

click the "new" button at the bottom of your form. The last button in the
record navigation buttons takes you to a new record. It looks like a right
arrow followed by an asterisk.

To make your form default to the new record, add vba coding to the form's
OnOpen event procedure such as...

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub




Rick B



"Vaughan" wrote in message
...
I feel this must be the most basic question, but I just can't figure it out.

I want to create a form that will allow me to add a new record to my
database. I have designed the form and linked it all up to the data base,
but when I open the form, the first record is displayed and I have to tab
through all the records to the end of the table to get a new one. I don't
want to do that, and I don't want to risk someone changing the existing
records, so I want the form to zip straight to adding a new record, without
giving the option of modifying the existing ones.

Please, just point me in the right direction.

Thanks

Vaughan

"Vaughan" wrote in message
...
I feel this must be the most basic question, but I just can't figure it
out.

I want to create a form that will allow me to add a new record to my
database. I have designed the form and linked it all up to the data base,
but when I open the form, the first record is displayed and I have to tab
through all the records to the end of the table to get a new one. I don't
want to do that, and I don't want to risk someone changing the existing
records, so I want the form to zip straight to adding a new record, without
giving the option of modifying the existing ones.


The form has a property named DataEntry. You'll find it in the property
sheet while in design view. Set that to Yes and the form will not display
existing records when opened but will only display a blank form for adding
records.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Also...

If you only want to allow new records to be added through a form (and have a
different form to modify them) then you can set the form's "Data Entry"
property to "Yes". This will open the form to a new record, and not allow
the users to access any existing records.

Rick B

"Vaughan" wrote in message
...
I feel this must be the most basic question, but I just can't figure it out.

I want to create a form that will allow me to add a new record to my
database. I have designed the form and linked it all up to the data base,
but when I open the form, the first record is displayed and I have to tab
through all the records to the end of the table to get a new one. I don't
want to do that, and I don't want to risk someone changing the existing
records, so I want the form to zip straight to adding a new record, without
giving the option of modifying the existing ones.

Please, just point me in the right direction.

Thanks

Vaughan

Change the Data Entry property on the form to Yes.

-----Original Message-----
I feel this must be the most basic question, but I just
can't figure it out.

I want to create a form that will allow me to add a new
record to my database. I have designed the form and linked
it all up to the data base, but when I open the form, the
first record is displayed and I have to tab through all
the records to the end of the table to get a new one. I
don't want to do that, and I don't want to risk someone
changing the existing records, so I want the form to zip
straight to adding a new record, without giving the option
of modifying the existing ones.

Please, just point me in the right direction.

Thanks

Vaughan
.

Vaughn,
The easiest way is to edit the Switchboard item and set
the Command box to "Open Form in Add Mode".


-----Original Message-----
I feel this must be the most basic question, but I just
can't figure it out.

I want to create a form that will allow me to add a new
record to my database. I have designed the form and linked
it all up to the data base, but when I open the form, the
first record is displayed and I have to tab through all
the records to the end of the table to get a new one. I
don't want to do that, and I don't want to risk someone
changing the existing records, so I want the form to zip
straight to adding a new record, without giving the option
of modifying the existing ones.

Please, just point me in the right direction.

Thanks

Vaughan
.

Thanks to you all for your help. I knew it had to be simple. It now feels like I can make a whole lot of progress.

Thanks again

"Vaughan" wrote:

I feel this must be the most basic question, but I just can't figure it out.

I want to create a form that will allow me to add a new record to my database. I have designed the form and linked it all up to the data base, but when I open the form, the first record is displayed and I have to tab through all the records to the end of the table to get a new one. I don't want to do that, and I don't want to risk someone changing the existing records, so I want the form to zip straight to adding a new record, without giving the option of modifying the existing ones.

Please, just point me in the right direction.

Thanks

Vaughan