Collapse control in subform

[edster]

I'm designing a quotes database and have a problem, I want to add an optional 'Comments' field for each product in the subform so the user can select if they add a addition comment in that product line or not. Default setting is that it isn't shown, when they select 'Add Comment' the text box appears.

I tried to use a toggle button using this code:

[Comments].Visible = Not [Comments].Visible
[Comments].Height = 2000 - [Comments].Height

It works but it shows the control in all of the subform records not just the one I press the button in.

Any ideas?

 

[jkl0]

I am assuming your subform is a continuous form.
It may be easier to to create a pop-up form to insert your comments.