forcing acCmdFind to search within subform/query

[samymelbourne]

I am at a wits end. Any and all info greatly appreciated in advance!

I have subform when I click on that subform, which is in datasheet view, to
select all fields (all fields are then highlighted) and then CTRL-F I get the
results wanted.

I would like to tie this process to a button in the main form.

I have tried the follwoing giving focus to the subform:
Me.ViewDBQuery.Form.SetFocus
RunCommand acCmdFind

and other variants but I get the error: There is an invalid error in an
expression Runtime error 2449

However this does not work.
Again Thanks.

 

[samymelbourne]

Solved It... try..

DoCmd.GoToControl "ViewDBQuery"
RunCommand acCmdFind