MS Access FORM

I created A table with two fields Name and ID. Table Name is CMA.

I created a form on MS Access with two text boxes and one button to insert into the CMA Table.

How can I achieve that as it is not saving?

Thanks
LVL 1
ramziabkAsked:
Who is Participating?
 
mbizupConnect With a Mentor Commented:
Once you get the recordsource setting correct, do this for each of your textboxes...

- Bring up the property sheet for the textbox
- Select the correct field from the list of options in the control source setting (also under the Data tab in the property sheet)

Property Sheet - Control Source
I'd recommend digging into a basic, general tutorial on Access - let us know if you want some suggestions for that.
0
 
mbizupCommented:
Look at the RecordSource property of your form.

What is it's current setting?

If you set the recordsource to CMA and the Control Sources of your textboxes to Name and ID., your values will save automatically.
0
 
Rey Obrero (Capricorn1)Commented:
open form in design view

set the Record Source of the form  to CMA

set the Control Source of textbox 1 to ID

set the Control Source of textbox  to Name

this will make the form Bound to the table
records you enter in the form will be automatically saved when you move to New record .
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
ramziabkAuthor Commented:
I'm using Access 2007.

Can't see a property called Record Source for the Form!!!
0
 
mbizupCommented:
Look in the form's property sheet - under the Data tab.

It is the property listed at the top.
0
 
mbizupCommented:
Property sheet- recordsource
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.