Link to home
Start Free TrialLog in
Avatar of bill201
bill201

asked on

how to set a filter on a open form in microsoft access 2013 with vba

i have an open form and i want that when i press some command it's will filter the form to show only records that the price is 150 how i set this with vba

something like this :
Me.Filter = "[price] = 150
  Me.FilterOn = True

thanks
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bill201
bill201

ASKER

thanks for your answer, it's was another syntax issue,thanks alot
Avatar of bill201

ASKER

excellent thanks alot