Setting parameters for FindRecord

[Guest]

I have added a command button to find a record. I would like to change the
default value of the "Match" field to "anypart of the field".

How can I do this

Using the Command button wizard, here is my code:

Private Sub cmdFindRec_Click()
On Error GoTo Err_cmdFindRec_Click

Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_cmdFindRec_Click:
Exit Sub

Err_cmdFindRec_Click:
MsgBox Err.Description
Resume Exit_cmdFindRec_Click

End Sub


Thanks

 

[Alex Dybenko]

Hi,
I think you can try to use SendKeys to set appropriate option in find
dialog. Or perhaps you can build your own custom form to find records, then
you can do everything

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Thanks Alex. I'll give it a try

Hi,
I think you can try to use SendKeys to set appropriate option in find
dialog. Or perhaps you can build your own custom form to find records, then
you can do everything

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com