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]

Re: How do I insert records from form

"Steve" <dafella007@yah oo.comwrote in message
news:17388224-225d-4872-9494-a6cf7dfbfae7@j6 8g2000hsf.googl egroups.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.

https://www.keithwilby.co.uk

[jonceramic]

Re: How do I insert records from form

On Oct 16, 6:34 am, Steve <dafella...@yah oo.comwrote:

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:RunComma nd
Command: SaveRecord

Or write VBA code that says:
DoCmd.RunComman d 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