Tick box (multiple ticking button)

[james_IT]

hi,

i have a form of customer details and a subform with their purchase of stock below it. I want to create a button so that when clicked it ticks all the boxes in the subform for the "Sold?" column. There may be mulitple pieces of stock, so i want it to tick ALL the boxes in that purchase.

What would the code be? the form is called "Sales" and the Subform is called "Stock sub".

Thanks

 

[GaryPanic]

do this as a qry
so get your qry to update or append
all the sold Values to yes/true/0
then assign the qry to the button
regards

 

[james_IT]

but wont that tick/untick ALL records? i only want to tick/untick the pieces of stock that the customer is purchasing, not every record in the database. is there not some sort of VBA/code that could be used on click of a command button to tick/untick those selected records?

 

[Rich]

Wht if the customer wants more than one item of the same piece of stock?

 

[james_IT]

the stock is carpets, there is only ever unqiue pieces of stock. therefore customer would only purchase one, two or tree rolls of carpet, all different