Form to add new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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



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 said:
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
Click to expand...
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.
 
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

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
Click to expand...
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.
 
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
Click to expand...
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.
 
Back
Top