Can I carry out an event for multiple controls?

[wrekless]

I have a continous form, each line displaying about six fields. I have it set up so that if the first field is double clicked, another form opens up showing all the details of that record.

Is there any way I can set it up, so that if anywhere on the line (any one of the six fields) is double-clicked, the 2nd form will open???

 

[Travis]

Try using the DoubleClick event of the Details section of the form. Otherwise you will need to add the code to the doubleclick of each field. I recommed if its longer then one line to make the opening of the second for a Private Sub called by the double click of each field. This way you can change things without having to make that change six times.