unbound check box for each record

[samjesse]

Hi
Working with Access 2000
I have a Continuous subform based on a query based on few linked tables.One of those tables has a Yes/No field which shows in the subform.
I want to be able to change the status of this field for each record independently, so I placed an unbound check box in the subform Detail section and a Command button on the subform Header section on the hope of coming here to ask for further help. However when I click one record check box, all of them change, I did not expect that.
how do I move forward to get this done?

many thx

 

[David R]

If you want to "change the status of this field for each record independently", you should probably bind the checkbox to a field.

What is the purpose of this checkbox - printing selected records, or something? You can always blank it later.

 

[samjesse]

If you want to "change the status of this field for each record independently", you should probably bind the checkbox to a field.

What is the purpose of this checkbox - printing selected records, or something? You can always blank it later.

Well. I tried to bound it to the records of Yes/No but it will not let me change the status.

 

[pr2-eugin]

Show the RecordSource and explain exactly what you mean by

...it will not let me change the status.

 

[David R]

And what the checkbox is for, we may have another idea that will save you pain and suffering.

 

[samjesse]

Show the RecordSource and explain exactly what you mean by

When I click on the Yes/No field "which is also a check box" the computer gives a short beep and nothing changes. tblSold.Paid is what I am trying to update.

SELECT tblItems.Name, tblSold.BuyerID, tblSold.ShippingID, [Shelf] & [SupplierListID] AS Location, tblSold.Paid
FROM (tblSold LEFT JOIN tlbIDs ON tblSold.ItemID = tlbIDs.ItemID) INNER JOIN tblItems ON tblSold.ItemID = tblItems.itemID;

 

[pr2-eugin]

Might be that your Query is Read only.. See if this link gives you an idea why : http://allenbrowne.com/ser-61.html

 

[samjesse]

Might be that your Query is Read only.. See if this link gives you an idea why : http://allenbrowne.com/ser-61.html

It is read only because it has JOIN but that is inherent in the relationship. Are you suggesting that I rethink/change the relationship between tables?
Is there another solution?

thx

 

[David R]

Did you read the link? There are a lot of reasons a join might be read-only, but not all joins are. You might want to post your JOIN SQL.

Also, you still haven't told us what this checkbox does.

 

[samjesse]

Thank you for helping.
I changed the relationships and removed on table from the underlying query, got it to work and the missing field from the deleted table I got it in using a Dlookup clause.

 

[David R]

Glad to hear you got it working.