set focus on detail section of a sub form?

[jebushatescats]

Hello all
I have a form called x
a subform within the form called y

the subform y has a header, a footer and a detail section.
The detail section has fields that display values from fields within a table record.

Can anyone tell me how I set focus to the detail line within the detail section of my subform?

 

[Remou]

To move to a specific line, you can use the Recordset of the subform.

For example:
[tt]Me.[Subform Control Name].Form.Recordset.MoveLast

Or

Set rs = Me.[Subform Control Name].Form.Recordset
rs.FindFirst "ID=3"
Me.[Subform Control Name].Form.Recordset.Bookmark = rs.Bookmark[/tt]

 

[seaport]

To set focus on a control in a sub-form, you need to set the subform on focus first, like,

me!y.setfocus
me!y.form!Control1.setfocus

Before that, you can use Remou's code to move to a specific row in the subform first.

Seaport