Check Box procedure to update table

[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 tick box is ticked and No
when it is unticked.

Is there an easy way to achieve this ?

cheers,

Adam

 

[Larry Linson]

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 tick box is ticked and No
when it is unticked.

Is there an easy way to achieve this ?

In which _Record_ of the tblNotesToPrint do you want to change the
selectedYN field to Yes? Is the selectedYN field a Yes/No field, or some
other representation of Yes and No? DAO code is not difficult, but you do
have to have all the neccessary information.

Just as a matter of interest, why are you working with an unbound form? Is
it for navigation (something like a switchboard) or is it for selection
(limits in a report)?

Larry Linson
Microsoft Access MVP

 

[acs68]

Sorry Larry - I'll explain further.

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. And yes, it is a Yes/No field type..

With the form and why it's unbound -
I have a form that gets data from our main Financial Package via ODBC. It
basically fill the text boxes and populates various fields on the unbound
form. I then merge it into Word.

cheers,

Adam