Solved

How do i create a checkbox on a Access Form that is not bound to the database.

Posted on 2002-04-01
3
195 Views
Last Modified: 2012-06-27
How do i create a checkbox on a Access Form that is not bound to the database. All i need is some code to run when the box is checked or unchecked
0
Comment
Question by:MrCrawfish
3 Comments
 
LVL 9

Accepted Solution

by:
Volibrawl earned 100 total points
ID: 6911558
Just pcik it from the tools and put it there.  It does not have to be bound.

Then you can refer to it Forms!MyForm.CheckBox1


If Forms!MyForm.CheckBox1 = -1 then
do something
Endif

0
 
LVL 6

Expert Comment

by:Mach1pro
ID: 6911638
If you are using a continuous form, you will need to add the Checkbox as a YesNo field in your underlying table. Otherwise a selection to one checkbox changes the selection for the checkbox on all records.
0
 

Author Comment

by:MrCrawfish
ID: 6911666
Thanks volibrawl... your are an EXPERT...
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

705 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

18 Experts available now in Live!

Get 1:1 Help Now