checkbox checking on tabular form

groengoen

Registered User.
Local time
Today, 19:31
Joined
Oct 22, 2005
Messages
141
I have a table in tabular form on a form. The table has a field PrintBill which is a checkbox. When I click on this field in one row of the table all the other rows are checked. I only want to check the rows one at a time. What am I doing wrong? below is the code I use:
_____________________________________________________________
Private Sub PrintBill_Click()
Me!PrintBill.Value = True
End Sub
______________________________________________________________

I have attached the form below and here is the SQL for the fields
___________________________________________________________

SELECT Clients.Name, Requests.PaymentID, Membership.PaymentID, tblPrintBills.PrintBill, tblPrintBills.UnpaidMembership, tblPrintBills.UnpaidRequests
FROM ((Clients LEFT JOIN Requests ON Clients.AgtID = Requests.AgtID) LEFT JOIN Membership ON Clients.AgtID = Membership.AgtID) INNER JOIN tblPrintBills ON Clients.AgtID = tblPrintBills.AgtID
GROUP BY Clients.Name, Requests.PaymentID, Membership.PaymentID, tblPrintBills.PrintBill, tblPrintBills.UnpaidMembership, tblPrintBills.UnpaidRequests, Clients.AgtID
HAVING (((Requests.PaymentID) Is Null)) OR (((Membership.PaymentID) Is Null))
ORDER BY Clients.Name;
 

Attachments

It would appear that your checkbox is an unbound control and unbound controls on a continuous form will always display the same data as any other one of itself.
 
Thanks very much. I will "bind" it immediately
 

Users who are viewing this thread

Back
Top Bottom