Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
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 August 25th, 2006, 08:47 AM
Authorized User
 
Join Date: Aug 2006
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default Change Textbox and have checkbox checked

Hi there,
  I'm pretty new to VBA and have a question. I have a textbox which whenever it is changed, I need a checkbox to be checked unless another checkbox is checked.

Textbox (ISBN)
Checkbox to be changed (Changed) unless another checkbox is already checked (New)

Can anyone help explain it to a new guy?

Thanks,
Arholly

 
Old August 25th, 2006, 10:22 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 142
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Set up an "After Update" event in the text box properties to [Event Procedure], and click the ... button. The code you want in the procedure would be something like this, with the correct names subbed in:

If me.chkNew = False Then
me.chkUpdate = True
End If






Similar Threads
Thread Thread Starter Forum Replies Last Post
Checkbox checked all mateenmohd Javascript 1 January 2nd, 2007 06:19 AM
checkbox checked by default by html:checkbox sachin.tathod Struts 3 December 4th, 2006 03:41 PM
Checkbox checked? ninel ASP.NET 2.0 Professional 1 April 12th, 2006 10:50 PM
allow only one checkbox to be checked! morpheus HTML Code Clinic 5 April 15th, 2004 10:59 AM
Display Checkbox if checked or not jmss66 Classic ASP Basics 6 January 23rd, 2004 11:19 AM





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