Find query

[TwoDodges]

I have a data base that opens to a members screen, then has a "find Replace" window overlaying it so I can "find" a member info by field....

Currently the default field is the Member surname in main form, and I want the "Find What" field on the search window to be Active field for input ...
At the moment if I start typing, it replaces Surname information, where I want to type in on search window [ "Find What" ] the information I am looking for without having to select it before entering search criteria



How do I get the find what field to be automatically active when this window come up..??

[alansidman]

Private Sub Form_Load()
Forms!YourFormName.FindWhatField.SetFocus
End Sub