Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

RE: Adding new information via a form Version: 2003 (11.0

sooragssoorags Member Posts: 18
I have created a standard form to add new data to my database but when the form is opened it displays data already stored. I then have to scroll through all of the data shown on the form to the bottom where I can add new data. How can I change this form so that it does not show the rest of the data but lets me just enter and save new data (without having to scroll through the existing data?) The database is attached and I would be grateful for any help. You get to the form by clicking on frmMain and then going to Amend Directory and then Add New Business Information. Thank you.

Comments

  • dokken2dokken2 Member Posts: 532
    : I have created a standard form to add new data to my database but
    : when the form is opened it displays data already stored. I then have
    : to scroll through all of the data shown on the form to the bottom
    : where I can add new data. How can I change this form so that it does
    : not show the rest of the data but lets me just enter and save new
    : data (without having to scroll through the existing data?) The
    : database is attached and I would be grateful for any help. You get
    : to the form by clicking on frmMain and then going to Amend Directory
    : and then Add New Business Information. Thank you.


    2002 code but should work for 2003, in the formload event move to a new record-

    Private Sub Form_Load()
    'DoCmd.GoToRecord acDataForm, Me.name, acNewRec
    DoCmd.GoToRecord , , acNewRec
    End Sub
Sign In or Register to comment.