User input filtering records

[Moss100]

Hello,

I would like to be able to filter a form using criteria input by the user.

So in the code:

DoCmd.ApplyFilter , "Property_Address_1 = like'*" & [Please Enter Start of Street Name] & "*'"

I was hoping that [Please Enter Start of Street Name] would make access pop up an input box prompting the criteria to be entered into. Unfortunately it doesn't.

How could I acheive this?

Many thanks Mark

 

[PHV]

Have a look here:
faq701-6763

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886