Enter Data from a Form into a Table

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

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---
 
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.
 
Back
Top