Forms: VBA to set focus to form's default search box (at the bottom of the form)

[anwarvety]

I have a main form and a subform in it.
I need in main form's onload event property
to set focus to subform's default search box
that is located in record navigation bar at the bottom of every form

Plz help

[Xipooo]

I don't know know of a way to set the focus to the navigation controls, never had to try that since I prefer making my own navigation controls. I would suggest you do the same. Make your own textbox for a search box and filter your subform data source with a query that uses a filter based on the text in your text box.

[Missinglinq]

I don't know know of a way to set the focus to the navigation controls, never had to try that since I prefer making my own navigation controls. I would suggest you do the same. Make your own textbox for a search box and filter your subform data source with a query that uses a filter based on the text in your text box.

That's the same approach I suggested where the OP double-posted the problem, here:

http://www.utteraccess.com/forum/VBA...2#entry2441502

Linq ;0)>

[anwarvety]

Yes Missinglinq

It's OK Now....

Thanks for your help on both sites .......

[anwarvety]

Thanks a Lot Xipoo

As you suggested,
I created the search box with the help of Allen Browne's Module ajbFindAsUType

That's working .....

[Xipooo]

Good to hear. Thank you for marking the thread as solved.

Cheers.