Set Focus on a field clicked on subform 2

[cfvcf]

I have other applications that work fine, where you have a mainform and a subform. If you click on the ID on the subform, I want to open the detail record of that ID on another form. For some reason, I now have the same types of forms, but the focus is on the first record on the subform. If I click on another record in the subform, it doesn't get focus until I click on the row indicator >. Then it gets focus. I want to allow the user to click on any ID in the subform and it then links to the detail form. Now if I click on another ID I must move the focus by clicking the row indicator > to that particular record. When I do move the focus, it works great. Any ideas? Thanks!

 

[jordanking]

what type of control is the ID?

.....
I'd rather be surfing

 

[cfvcf]

It's a text box, the table field is an autonum type. On the form I have it "not enabled" and "locked".

 

[PHV]

"not enabled" and "locked"
How a not enabled control may get the focus ????

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jordanking]

so do users click the text box? In my application with a similar purpose, I use a command button that says details(to trigger opening another form with full details of the specified record), and leave the other data fields locked and not enabled. This form has no record selectors etc.



.....
I'd rather be surfing

 

[cfvcf]

Yes they click the text box which just displays the ID, then it has a click event to open the detail form.

PH, I changed the subform enabled to Yes and Locked to No and the main form with the subform the same way and it works. I'm just baffled that I have an application that works correctly with the Enabled No and the Locked Yes in the subform and the mainform.

But you know if it works, maybe I've got other things I should focus on. Just curious though, which properties take precedence, the subform or the form that uses the subform. Thanks to you both for your responses.