Dynamic Find Button

[ddtpmyra]

If I use the wizard to built a find button it will generate below codes. But what about if I wanted to have two fields how will I do that?

Private Sub Command33_Click()
On Error GoTo Err_Command33_Click


    Screen.PreviousControl.SetFocus
    DoCmd.RunCommand acCmdFind

Exit_Command33_Click:
    Exit Sub

Err_Command33_Click:
    MsgBox Err.Description
    Resume Exit_Command33_Click
    
End Sub

[jimatqsi]

Here is a very good insight article about filtering data on a form, posted by NeoPa.

http://bytes.com/topic/access/insights/893657-cascaded-form-filtering

Jim