Filter in ADP code

[Aliffi]

Dears, as i was working with Access Forms
i could create Text box with a button , behind button i would set this code to match and then filter up data inside a form.

docmd.applyfilter ,"", "[Contract_details]![province]=[Forms]![filter_form]![Text116]"

but now , iam using ADP .Access Project form
which this functionailty does not work or exitst

can you helpe me plz

what i want is to have a text box when i write something in text box it should match it with a field in the current form and then , filter it.

regards

 

[PaulBricker]

Worked fine for me but the syntax you are using didn't. Here is what I used.

DoCmd.ApplyFilter ,"province = '" & Forms!filter_form!Text116 & "'"

This syntax assumes province to be a text value. If it's a numeric datatype, then get rid of the single ' quotes.


Paul

 

[Aliffi]

thank you paul you are greate ....... it really worked