Enter Data from a Form into a Table

[ryguy7272]

I have a Form bound to a Table; all data is entered into the Table via the
Form (pretty simple setup).

#1)
I am wondering if there is a way to enhance the user experience by having
the Form open to the first blank record, instead of the first record in the
recordset. This seems simpler and would save a step or two (i.e., not having
to click those ‘Last Record’ and then ‘Next Record’ buttons at the bottom of
the Form to get to the first empty record).

#2)
I am wondering if there is an easy way to add new records to a Table, but
clicking a button and have a snippet of VBA run, and commit the records to
the table, rather than click the ‘Next Record’ button.

Thanks for the help!
Ryan---

 

[Daryl S]

Ryan -

#1) If you open the form in Data Entry mode, then it opens to the new
record. Once the user tabs past the last control on the form, it goes to the
next new record. In this mode, you do not even see the records added
previously. If your users get to this form from a main menu or switchboard,
you may want to have two buttons - one to Add Records (e.g. open the form in
Data Entry mode), and another button to View Record (e.g. open the form not
in data entry - maybe read-only?)

#2) In Data Entry mode, tabbing out of the last record will save it and put
the user on another new record. You can, of course, put a button on the form
that simply goes to the next record. The button wizard makes this one easy.

 

[Linq Adams via AccessMonster.com]

This will take you to a new record on loading, while still allowing display
of existing records:

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

To explicitly save a record without leaving it:

Private Sub SaveRecordButton_Click()
DoCmd.RunCommand acCmdSaveRecord
End Sub

 

[ryguy7272]

Great idea Daryl! I found my answer here:
http://blogs.techrepublic.com.com/msoffice/?p=126

This method seems to do just what I want. Also, I tried the Add Record
button and that worked great too!

Thanks so much!!
Ryan