Add Record Button

[AccessNewb89]

Hello All,

I have a simple table and I created a form for the table in order to make adding new records easier. I created an add record button but when I fill in the fields and press add record all that happens is it brings me to a new form but I want the button to bring me to a new form and store the added data into my table. What am I doing wrong?

Additionally, once I added the button I could not save the form and got this error:
"This form or report contains changes that are incompatible with the current database format. The form or report was not saved." It then goes on to tell me to remove any layouts that have empty cells but what does that mean?


Sorry i'm sure its simple but I just started using access like yesterday.



Thanks

[pradeep.sands]

I would suggest you this:
In the main form have a button something like "Add" and go to event procedure and make it to open new form (like u mentioned) upon clicking it. Then in the new form you can design a layout to have all required fields to fill as in the table and in same order. When the data is entered here, it automatically gets updated in the table. Then at the bottom of this form, have two more buttons like SAVE and ADD NEW and then create a Macro for these two actions.

[pradeep.sands]

And in your new form, did you link the fields when u enter ur text to the respective fields of the table? (do this in the Propertysheet--> Data--> ControlSource)

[AccessNewb89]

Yes I linked all the fields in the form to the fields in the table. I think my problem is I don't know what the code should be in order to acomplish the task I want. (I am new to VB and macros altogether)

This is the code that automatically populated when I created my "add new record" button. I was under the impression that the "add new record" button added a new record to your table and cleared the form so that the user could add another record

Private Sub SubmitButton_Click()
On Error GoTo Err_SubmitButton_Click

DoCmd.GoToRecord , , acNewRec
Exit_SubmitButton_Click:
Exit Sub
Err_SubmitButton_Click:
MsgBox Err.Description
Resume Exit_SubmitButton_Click

End Sub

[TG_W]

Two suggestions:

First:
Have an "Add" button that opens a "new" form and have that new form call the same table in a similar form but in "Single Form" and filter to the new record line. You can add a button on this second form that would simply go to the next record, which should save the data entered.

Second:
Have the "Add" button open a similar looking form, but remove all binding from the Text Boxes. Add the code below changing the form and Text Box names to suit your needs. The code below closes then reopens the entry form to make inputting more than one new record easier, but you can set it to go back to your main form.

Dim dbs As Database, rst As Recordset
    Set dbs = CurrentDb
    Set rst = dbs.OpenRecordset("Select * from YourTableNameHere")
        
        rst.AddNew
        rst!Field1 = Forms!YourEntryFormNameHere!CorrespondingField
        rst!Field2 = Forms!YourEntryFormNameHere!CorrespondingField
        rst!Field3 = Forms!YourEntryFormNameHere!CorrespondingField
        rst!Field4 = Forms!YourEntryFormNameHere!CorrespondingField

    Set dbs = Nothing
    rst.Update
    rst.Close
        
DoCmd.Close acForm, "YourEntryFormNameHere"
DoCmd.OpenForm "YourEntryFormNameHere"

[AccessNewb89]

Thank you for all for the suggestions. For the sake of simplicity, I would like to only have one button and one form if possible to be used for data entry. Let me explain in more detail what I am doing. I have been tasked with making entering data into a database more simple. I simply have a database and would like to have a form with one button which will submit the entered data into the database and clear the form so that the next record may be entered. Multiple people will be using this to enter in the data. Am I just not thinking of accomplishing this in terms of the way Access works? Can I not make a simple modification to the code I already have so that the entered data on the form is stored in my database and so that the form is cleared, ready to accept new data?

[AccessNewb89]

This seems like a pretty standard task is there some built in function that does this?

[TG_W]

The "Add New Record" button just jumps you to the open record line your table.

If your data entry people do not need to review the data, then just have one entry form for them to use, and you can use the code I provided. I can attach a sample database showing the use if needed.

There isn't a simple built-in function like Excel might have other than having the Form show in 'Continuous Form' and have the users enter data and keep pressing 'Tab' or 'Enter' to get to a new record when they complete the current record.

EDIT:

or have them left-click the pencil to the left of the screen when they have completed entering data for the last record.

[AccessNewb89]

Ok I got it now. Thanks!