A Novice needing help with a Form.

[Steven]

Hi,

I'm new to using Access. I have created a simple database
for my companies IT team to track calls taken for support.
Currently I have a form designed for the data entry that
is working very well.

I would like to get the following to happen:

1)When the form is opened have it open a blank record for
data entry.

2) Add a "Submit" button to the form that would save the
record.

3) Add a "New Call" button that would take you to a blank
record.

Any thoughts or help would be greatly appreciated.

 

[Ken Smith]

If you are using a switchboard, set the controls to open
in the form in Add mode rather than Edit mode. You'll
probably wnat a button to pen the form in edit mode too so
you can review the records.

You can skip the submit button. Acccess automatically
saves the changes as soon as the form or the database is
closed, or if you add another record. Othwise, notice the
record selector bar on the left of your form. When editing
or adding data the figure is a pencil rather than a
diamond. That means you are writing data. Click the bar
and it saves the data and keeps the record on screen.

You can add a command button to add a new record by
opening the form in design mode and putting a command
button on the form using the wizard.