Click on record in subform to open a new form

[bowserj]

I have a form that displays information about an employee, including a subform showing various destinations and the mileage the employee has to travel to get to that location. These are both text boxes on the subform. I want to be able to click on a record (either the destination, or the mileage) and have it open a form to allow me to change that information. I have tried putting this in the detail_click() event of the subform, but this event only fires when the user clicks on the first record displayed on the subform. I have implemented this on other forms/subforms, and through experimentation, I have found that if there is a checkbox, or a button present on the subform, the event fires properly, but if there isn't the click is ignored. Is there a focus issue that I am missing or something....

I am out of ideas and ready to put a command button with no caption and no code on the subform, since it's presence seems to make what I want to happen work.

Thanks in advance...

 

[MajP]

I want to be able to click on a record (either the destination, or the mileage)

Then the event should be on the on click events of your text boxes.

 

[TheAceMan1]

How are bowserj . . .

How about the forms [blue]On Dbl Click[/blue] event? ... here you just double click the record selectors! . . .

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]