Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 12th, 2006, 09:18 PM
Authorized User
 
Join Date: Feb 2006
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default check box problem

Hi,

I have created a form that is bound to a table.
The form's working fine.

But I now need to add a check box to the form.
This checkbox is not bound to any column in the table.
The problem is that because it's not bound to the column,
whenever I check / uncheck this checkbox in one of the form,
the other checkboxes will follow its state.

Hence, need some help in getting around this...
Thanks in advance

Scripts82
__________________
Scripts82
 
Old April 13th, 2006, 05:00 AM
Authorized User
 
Join Date: Apr 2006
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Unfortuantley, the only way I managed to find to get around this problem was to bind it to something, once it was bound, I had no problems.

Although contrary to that, I've got a form at the moment with tickboxes bound to nothing, and I can tick/untick them individually.

 
Old April 16th, 2006, 07:40 PM
Authorized User
 
Join Date: Feb 2006
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hmm... how did you do that?

Scripts82
 
Old April 18th, 2006, 10:06 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 142
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What is the point of the checkbox if it is not bound to a record?

 
Old April 19th, 2006, 03:48 AM
Authorized User
 
Join Date: Apr 2006
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It depends on what you want to do, if you want to scroll through the records for instance then yes, they do need to be bound.

However, if the form is simply for data entry and NOT for record browsing then you can use an INSERT statement executed on button click for instance.


http://p2p.neopian-hosting.com
A New Programming Chat Forum





Similar Threads
Thread Thread Starter Forum Replies Last Post
check box help? dstein4d Access VBA 2 February 27th, 2008 09:54 AM
Check BOx kaushikpulpa ASP.NET 2.0 Professional 2 August 30th, 2007 08:01 AM
check box problem Vince_421 Access VBA 3 March 1st, 2007 04:35 PM
Problem inserting value from Check Box vivekshah C# 3 June 8th, 2006 08:17 AM
problem reciving check box values using post metho method Pro PHP 1 March 10th, 2006 08:27 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.