Solved

Add Check Box to Access database

Posted on 2014-02-05
2
290 Views
Last Modified: 2014-02-06
Hi

I have a very basic access database which records some records that we hold in a file cabinet.  The database is about 2000 records and I need to add a check box field to it.  This I have done with no problems, however, when I check the box it checks it for all records instead of the current record only?  How can I configure the check box so that when it is selected it only affects the current record?

Thanks
0
Comment
Question by:Nick_D
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
IrogSinta earned 500 total points
ID: 39836044
Sounds like you have an Unbound checkbox.  Make sure that the ControlSource property of the checkbox is set to the field that you added.

Ron
0
 
LVL 2

Author Closing Comment

by:Nick_D
ID: 39838408
Thanks
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

691 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