i have a combo box that when i select a record, displays the corresponding subform on a form. the following is the code that does this:
Private Sub cboCostCentre_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[CostCentre] = '" & Me![cboCostCentre] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
however, i would like to add a component to "goto" a specific field once the subform is displayed. currently, the focus goes to the first field by default. [sig][/sig]
Private Sub cboCostCentre_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[CostCentre] = '" & Me![cboCostCentre] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
however, i would like to add a component to "goto" a specific field once the subform is displayed. currently, the focus goes to the first field by default. [sig][/sig]