saving problem

[jillp]

Although I am not experienced at Access programming even I have realised that Access likes to save the data.
But, somehow I have messed this up.



I have a menu that opens a form as follows:

DoCmd.OpenForm "FrmNewScore"
Forms!frmnewscore!ScoreName.SetFocus

I then enter the details and have button that does a save and close as follows

If Me.Dirty Then Me.Dirty = False
   
    DoCmd.Close acForm, Me.Name

If I then look at the table it is there.
Until I do the next entry which just overwrites this one, I only ever have one entry in the table.

What have I done

[pbaldy]

By default a form bound to a table will display existing records when opened. That means you're overwriting the first record as you have it. If you want this form to only enter new records, set its Data Entry property to Yes. Otherwise, determine exactly how you want to use it and we'll go from there.

[jillp]

sorry, but where is the data entry property ?

[pbaldy]

It's a property of the form.

[Missinglinq]

• In Form Design View, Right-Click on the Form, itself
• Go to the Data Tab
• Set the Data Entry Property to Yes.

As Paul said, this will only allow the entry of New Records. You'd need a separate Form for the Viewing/Editing of Existing Records.

If you need to retain the ability to do all of these tasks on a single Form

• Forget about having the Data Entry Property set to Yes
• Set Data Entry Property back to No
• Add this code in the Form's code module

Private Sub Form_Load()
 DoCmd.GoToRecord , , acNewRec
End Sub

When the Form first Opens, it will be on a New Record, preventing the trigger-happy users from overwriting an existing Record. But existing Records will also be available, by use of the Navigation Buttons, to View or Edit those Records.

Linq ;0)>

[jillp]

thanks very much again, I have choosen separate forms to add / view for simplicity.