Thread: checkbox
View Single Post
  #3 (permalink)  
Old April 13th, 2005, 06:57 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Suppose you have a form with a textbox for the ID, your checkbox, and the button. Then on the button's ON CLICK event you put this (I'm using fake names since you didn't tell me yours):

Me.chkPassFail = Not IsNull(Me.txtID)

When the button is clicked, the value of the ID in the textbox txtID is evaluated to see if it's filled. If it isn't (Null) then the checkbox chkPassFail is not checked. If the ID field is filled then the checkbox is checked.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote