Solved

MS Access FORM

Posted on 2013-01-27
6
244 Views
Last Modified: 2013-01-28
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
0
Comment
Question by:ramziabk
  • 4
6 Comments
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
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
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
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
 
LVL 1

Author Comment

by:ramziabk
Comment Utility
I'm using Access 2007.

Can't see a property called Record Source for the Form!!!
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 61

Expert Comment

by:mbizup
Comment Utility
Look in the form's property sheet - under the Data tab.

It is the property listed at the top.
0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
Property sheet- recordsource
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
Comment Utility
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

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now