Search Record

[Guest]

Hi,

I want to click on a box in the form and a FIND dialog box appears. This
box show be able to find any thing in all records.

If i type TV in the box, it would search TV in all records.

Please Help, thanks.

 

[JohnFol]

There is a button wizard that does the code for you. All you then do is
stick the code into the appropriate OnClck event, ie
in nWind this will work on the Categories form


Private Sub Description_Click()
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
End Sub