How do I insert records from form

[Steve]

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

[Keith Wilby]

"Steve" <da********@yahoo.comwrote in message
news:17**********************************@j68g2000 hsf.googlegroups.com...

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

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

[jonceramic]

On Oct 16, 6:34*am, Steve <[e-mail]:

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

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