Want to use existing form to add new records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm helping a friend with her Access database. She has a form that will
allow her to browse through her records.
I'm trying to set up a menu to simplify the use of the data because other
people in her office will be using it and they aren't familiar with Access.

I want to set up a menu command button to "Add New Record" which will open
her existing form on a new record. Right now, whenever I open the form, it
positions a record #1 of the table.

What is the difference between an "Input form" and an "Edit form"? Is it the
DataEntry property? If so, can my command button run a macro that sets this
property to "Yes" in order to add a record when I open the form? Do I need
an "Update" button on the form to save the new data?

Thanks,
Jim
 
You can use acFormAdd in the DataMode argument of the OpenForm method and
execute that statment in the Click event of the command button. For full
details, look in VB Editor Help for "OpenForm"
There is no such thing as Input or Edit forms. These terms may be related
to the properties of the form that define whether adds, deletes, or edits are
allowed.
You do not need an update command button. There are several actions that
cause a record to be inserted or updated. In fact, it is harder to avoid an
update than to execute one. Any time you close the form, move to another
record, add a new record the current record is updated.
 
An input form is for adding it will open to the end of the db and display a
blank form for input. The count is for the opening instance so if you input
2 records it will state you have input 2 records even thought there may be 10
records total in the db. The open in edit makes all records in the table
available and opens on the first record as it was input unless something
tells to orderby or open descending or something.\

The command button has a select to open as input or add mode instead of edit.

Dwight
 
Thanks, it works perfectly and I learned a lot.
Jim

PS
How do I rate these responses? I don't see any controls to rate them, nor
does right-clicking give me any means to rate them.
 
Back
Top