Hi,

I have a form with a sub form and I created a button to search the text on the subform for a specific entry. However, the focus is always on the previous control (a dropdown menu) rather than on the subform. How do I change focus to the subform (called rptBugList1) before the search starts? On another note, can I force a wildcard (so someone doesn't have to add the "*" a the end of a partial word search)? Thanks!
Current code is below:



Private Sub Find_Click()

On Error GoTo Err_Command30_Click

Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_Command30_Click:
Exit Sub

Err_Command30_Click:
MsgBox Err.Description
Resume Exit_Command30_Click

End Sub