Form in Data Entry mode

[Guest]

Hi,

On my switchboard, I have an option called "Enter New Job". When clicked,
the command button calls a macro that opens our Main Form in Data Entry mode
and gives you a blank form in which to do data entry.

There is also a command button on the menu bar called "Enter New Job". You
can use it to get a new blank record if you want to enter more than one new
job. Right now, all the "new jobs" you enter remain visible until you exit
the "Enter New Job" form and go back to the switchboard.

What I would like to do is provide a command button called "Save New Job"
which will then "hide" the new job just entered, before providing a new blank
record. This way, you will always have just a blank record to fill in,
rather than all the jobs you entered in addition to the blank form.

Do I use the macro to accomplish this?

Thanks,

 

[Penguin]

Try using this code in the OnClick of the button:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.RunCommand acCmdRecordsGoToNew

Hope this helps.