Troubleshoot Find Button

G

Guest

Hi

I have placed a command button on my form using the wizard, which should
allow users to 'search all fields' of my query, but for some reason it's not
working.

If it's any help, when I click the button and the Find/Replace box comes up
the 'Look In' field is greyed out so I can't adjust it.

Code is as follows:

Private Sub Command30_Click()
On Error GoTo Err_Command30_Click


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

Exit_Command30_Click:
Exit Sub

Err_Command30_Click:
MsgBox Err.Description
Resume Exit_Command30_Click

End Sub

Any help most appreciated... the simpler the better, I'm not very
experienced with code yet.

Thanks

CastorandPollux :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top