Double Click event on subforms

[Danielle17]

I have a subform which contains activity information. It lists all of the acitivites for a certain day. Each activity has it's own ID number(primary key). I already have the form itself set up so that when the user types in the ID into a text box and clicks on a command button, the report will pop up. Is it possible to manipulate the code so that the user could click on the ID in the subform and have a report pop? I've tried a few things and so far none of them have been very successful. I'm not sure how to make the code identify a certain record in a subform....Any suggestions would be appreciated.

 

[Terpsfan]

You should be able to run an event on a subform control. However, I believe you have to have an instance of the subform already created apart from what's included on the main form. You run the event on that subform, not on the subform on your main form.

 

[JoeMiller]

You just need to reference the id properly. In the double click event of your form what is the code you're executing now? Joe Miller
joe.miller@flotech.net

 

[Shadez]

Yes Omega is correctI recently setup something exactly like wahat you are mentioning. You have to open up the subform in edit mode seperate of the main form. For some reason if you set the event while it is embedded in the main form it won;t activate. After setting up the event the subform will react in the way you specified.