Properly using checkboxes in a datasheet form

[Brent Ritchie]

Hello,

I want to use check boxes on a form in datasheet form that has a query
for a controlsource. Here is the basics of it:

I created a query that will return all the fields in one table then in
the next cell I am returning a value of -1 or 1 depending if one field in
both tables are the same (This is used for the checkbox). On the form is one
textbox and one checkbox that reflect the query when run, This is ok. My
problem is that when I try to click the checkbox I get a "Recordset is not
updateable" warning in the bottom left hand corner. All I want it to do is
execute the code in my clickevent handler which deletes or adds a field into
one of my tables and then requeries the query. I figured I could unbind the
checkbox, but I don't know how to keep the data in sync. Can anyone help?

I would rather not unbind my checkbox to the query I'm just looking for
a way to execute the code in my click event.

[Brent Ritchie]

Just for clarification I have my sql view code for the queries.

query 1:
SELECT tblCodeJurisdiction.Jurisdiction, IIf(IsNull([SiteID]),0,[SiteID]) AS
[This Site]
FROM tblCodeJurisdiction LEFT JOIN qrySubSiteJurisdiction ON
tblCodeJurisdiction.JurisdictionID = qrySubSiteJurisdiction.JurisdictionID;

query 2: (qrySubSiteJurisdiction)
SELECT tblSiteJurisdiction.SiteID, tblSiteJurisdiction.JurisdictionID
FROM tblSiteJurisdiction
GROUP BY tblSiteJurisdiction.SiteID, tblSiteJurisdiction.JurisdictionID
HAVING (((tblSiteJurisdiction.SiteID)=[Forms]![Transaction Info]![SiteID]));

[Brent Ritchie]

Actually sorry,

I just figured it out, It was the GROUP BY clause that was making things
break. I just removed it and changed the HAVING clause to a WHERE clause.
"Brent Ritchie" <br**********@personainternet.com> wrote in message
news:HC*******************@news20.bellglobal.com.. .

Just for clarification I have my sql view code for the queries.

query 1:
SELECT tblCodeJurisdiction.Jurisdiction, IIf(IsNull([SiteID]),0,[SiteID])
AS [This Site]
FROM tblCodeJurisdiction LEFT JOIN qrySubSiteJurisdiction ON
tblCodeJurisdiction.JurisdictionID =
qrySubSiteJurisdiction.JurisdictionID;

query 2: (qrySubSiteJurisdiction)
SELECT tblSiteJurisdiction.SiteID, tblSiteJurisdiction.JurisdictionID
FROM tblSiteJurisdiction
GROUP BY tblSiteJurisdiction.SiteID, tblSiteJurisdiction.JurisdictionID
HAVING (((tblSiteJurisdiction.SiteID)=[Forms]![Transaction
Info]![SiteID]));