Hide row using checkbox

[jamesharris]

Hi All,

I would like to hide a row in a subform when I select a checkbox, please see attchement.

Any ideas?

James :banghead:

 

[bob fitz]

How will you show the record again if you hide one by mistake?

 

[jamesharris]

Good point i do have another subform that displays all records situated above it so could view it in that.