Cycling Through Every Record in a table/subform When the boolean column is selected

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: nouveauricheinvestments@xxxxxxxxx
Date: Thu, 11 Dec 2008 12:31:11 -0800 (PST)

Hi,

I have a subform based on a recordset. I have a boolean column where
the user can select the checkbox to the left of the record. If the
user selects the checkbox, I want to check to see if the field exactly
to the right (DeptID) equals a field on my form. If it does, then
that fabulous. If not, then I want to uncheck all boolean values in
the table and display a message box. How would I do that?
.

Follow-Ups:
- Re: Cycling Through Every Record in a table/subform When the boolean column is selected
  - From: nouveauricheinvestments

Prev by Date: Re: Show Users Logged On
Next by Date: Lookup not showing records, also captions not displaying correctly
Previous by thread: Struggling to set the value of a field in a form automatically
Next by thread: Re: Cycling Through Every Record in a table/subform When the boolean column is selected
Index(es):
- Date
- Thread

Relevant Pages

Re: Cycling Through Every Record in a table/subform When the boolean column is selected
... I have a subform based on a recordset. ... I have a boolean column where ... the user can select the checkbox to the left of the record. ... If Not .EOF Then ...
(microsoft.public.access.forms)
Re: Unbound checkbox in subform datasheet
... Can you base this subform on a query, with a calculated field in the query? ... > recordset, and set the value of an unbound checkbox for each record in the ... where bit2 is the name of the unbound checkbox: ...
(microsoft.public.access.formscoding)
Painful problem for ya :)
... value from a recordset "talent_id". ... This works fine and the data displays as does the checkbox state. ... unticked checkbox doesnt send anything through $_POST so how do I get ... But If I have a lot of data, I'll have a tonne of session variables. ...
(comp.lang.php)
Re: Checkbox in form detail section not updating changes
... Is it a bound or unbound checkbox? ... Dim strObjectName As String ... Dim rstObjPerms As Recordset ...
(comp.databases.ms-access)
Re: Checkbox Array
... With radios, check boxes and buttons, only the values of selected, (or ... page to incorporate the ID of the record the checkbox represents. ... > I have an ASP form that uses a recordset to build a table, ... > causing the corresponding Update statement to write values to the wrong ...
(microsoft.public.inetserver.asp.general)