elyvalleyblue
Technical User
How do I create a search button on a Form in Access 97.
Can anyone help?
Cheers
Can anyone help?
Cheers
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I create a search button on a Form in Access 97
- Thread starter elyvalleyblue
- Start date
- Status
Hi
At its simplest, the answer is to use the command button create wizard, you will get code like so:
Private Sub Command89_Click()
On Error GoTo Err_Command89_Click
Screen.PreviousControl.SetFocus
DoCmd.RunCommand acCmdFind
Exit_Command89_Click:
Exit Sub
Err_Command89_Click:
MsgBox Err.Description
Resume Exit_Command89_Click
End Sub Ken Reay
Freelance Developer
kenneth.reay@talk21.com
At its simplest, the answer is to use the command button create wizard, you will get code like so:
Private Sub Command89_Click()
On Error GoTo Err_Command89_Click
Screen.PreviousControl.SetFocus
DoCmd.RunCommand acCmdFind
Exit_Command89_Click:
Exit Sub
Err_Command89_Click:
MsgBox Err.Description
Resume Exit_Command89_Click
End Sub Ken Reay
Freelance Developer
kenneth.reay@talk21.com
- Status
Similar threads
- Locked
- Question
