Using the "FIND" Facility in a Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have created a Form which includes a subform consisting of employee data.
I want to create a FIND button which searches for the employees in the
Subform. However, even though i have created the FIND button in the subform
when i open it in the main form the FIND doesn't work as the focus is set to
only serach the main form and not the subform. Does anyone know how this can
be changed?

Thanks
 
Try setting the focus on the subforms control to search. Use
Forms!FormName!ControlName.Form!SubFormControlName.SetFocus
then use your code.
 
Back
Top