|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 17th, 2004, 09:42 PM
|
|||
|
|||
CheckBox help
Hi all,
I have a form (unbound) with various tick boxes on it. I also have a table "tblNotestoPrint" with a Yes/No field called "selectedYN". I want to automatically change that field to Yes when the checkbox is ticked and No when it is unticked. tblNotesToPrint has 3 fields. The first field is a unique number PrintID. It is this number that needs to be selected and the Yes/No field changed to Yes or No respectively. clear as mud ? cheers, Adam 
|
|
#2
November 18th, 2004, 12:20 PM
|
|||
|
|||
|
-----Original Message----- Hi all, I have a form (unbound) with various tick boxes on it. I also have a table "tblNotestoPrint" with a Yes/No field called "selectedYN". I want to automatically change that field to Yes when the checkbox is ticked and No when it is unticked. tblNotesToPrint has 3 fields. The first field is a unique number PrintID. It is this number that needs to be selected and the Yes/No field changed to Yes or No respectively. clear as mud ? cheers, Adam .
|
|
#3
November 18th, 2004, 12:25 PM
|
|||
|
|||
|
Sounds like you want an update query that run when you
check and uncheck the check box. checkbox's after update event. I would put in qualifing code to prevent it from firing with out the other data: somthing like if isnull(me.txtPrintID) then msgbox("Need a PrintID Moron!") me.txtPrintID.setfocus exit sub end if -----Original Message----- Hi all, I have a form (unbound) with various tick boxes on it. I also have a table "tblNotestoPrint" with a Yes/No field called "selectedYN". I want to automatically change that field to Yes when the checkbox is ticked and No when it is unticked. tblNotesToPrint has 3 fields. The first field is a unique number PrintID. It is this number that needs to be selected and the Yes/No field changed to Yes or No respectively. clear as mud ? cheers, Adam .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Show time when checkbox checked | Michael | General Discussion | 4 | August 2nd, 2004 11:04 PM |
| Repost of Checkbox Help | ChrisBat | Using Forms | 3 | June 29th, 2004 05:09 PM |
| subform checkbox | bryan | New Users | 1 | June 17th, 2004 05:18 PM |
| Any reason why a checkbox won't allow a check to be made?? | Jacqueline | Using Forms | 3 | June 1st, 2004 04:28 PM |
Linear Mode
