Solved

MS Access FORM

Posted on 2013-01-27
6
267 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
ID: 38824226
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38824236
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
ID: 38824242
I'm using Access 2007.

Can't see a property called Record Source for the Form!!!
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 61

Expert Comment

by:mbizup
ID: 38824257
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
ID: 38824262
Property sheet- recordsource
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 38824272
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
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 …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

777 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