Update subform entire column

[paramesium]

Hi All,

I am working on a database project where I will Select a record on a subform

Please see the picture attached.

I know that using DAO recordset, i can update the checkbox one by one, but it become way too long when I have thousands of record...

May I know if there is a way to Select entire column of the subform?

Please advice, thank you!

 

[JHB]

Do you want to set the "Selected" for the whole table?
Then use an update query, use the QBE window to build the query.
Else try to explain what you want!