Is there a "Submit" button for Access forms to send the informati.

[Guest]

I have created an Access form, but I couldn't quite figure out how to make it
functional. I have multiple fields set up to gather information that I want
to be saved in a Database. Once someone fills in all the fields, how is the
information than saved to the DB? This is probably a very trivial question,
but I am new to Access and could not figure it out using any of the help
menus. Thanks for any help!

 

[Jim Evans]

Bind the Form to the table that contains the information you want to save.

Binding means to set the Record Source property of the form to the object
(table, in this case) That contains the fields to store the data. Each input
textbox on the form should be bound to the appropriate field in the table.

Jim Evans

 

[Jim Evans]

I would recommend using the Forms Wizard until you learn a bit more about
creating forms. After creating a form with the Wizard, you can go into
Design mode and view the Properties of the form to learn about what makes up
a form, and to customize the appearance of the form if you care to.

Playing with it this way is an excellent means of getting your feet wet.

Search Access Help for Forms to see the wealth of information available to
you on this subject.

Jim Evans

 

[John Vinson]

I have created an Access form, but I couldn't quite figure out how to make it
functional. I have multiple fields set up to gather information that I want
to be saved in a Database. Once someone fills in all the fields, how is the
information than saved to the DB? This is probably a very trivial question,
but I am new to Access and could not figure it out using any of the help
menus. Thanks for any help!

No Submit button is necessary; in fact you have to do some gyrations
to PREVENT Access from automatically saving the data!

Simply base the Form on your Table (the Forms Wizard does this for you
automatically). You fill in the fields, and when you either close the
form or move to a new record, for instance by pressing <Tab> or
<Enter> in the last field in the form's tab order, the record will be
written to disk. No code needed.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps