Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2002-04-01
3
Medium Priority
?
217 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 400 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

810 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