CheckBox help

[acs68]

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

 

[Guest]

-----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


.

 

[Guest]

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