All,
I'm not a big Access user - I'm developing a department database. It's
based on the Resource template.

I've created a form with a control for each field.
Once I select my submit button what is the proper code to insert
record

I have the following control types

textbox & Checkbox

Thanks
Steve

"Steve" <dafella007 (AT) yahoo (DOT) com> wrote

You don't need a submit button. To add a record press the navigation button
that looks like an arrow head and an asterisk >*

The data will be saved when you either navigate to another record or you
press the record selector.

Keith.
www.keithwilby.co.uk

On Oct 16, 6:34*am, Steve <dafella... (AT) yahoo (DOT) com> wrote:
As the other poster said, once you move to a different record, it's
saved. If you really want a "save record" button, then that's in
there.

Either make a macro that says:
Action:RunCommand
Command: SaveRecord

Or write VBA code that says:
DoCmd.RunCommand acCmdSaveRecord

Like Keith said, you don't necessarily have to do this. Typical case
I use save record is when I need to execute code that uses the record
you've been editing.

Jon