-
Search a Sub Form
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