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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter vba problem

Moss100

Technical User
Aug 10, 2004
578
0
16
GB
Hello I am trying to make a filter that filters the current form on click of a button.


I need it to filter the form by the following criteria

LL_Select - is an autonumber which is selected by cbo_LL_Select
DateStart - is the start date which is held in textbox txt_DateStart
DateEnd - is the end date which is held in textbox txt_DateEnd
Val - is true of false field which is held in chk_Val

Baisically I want the vba filter to filter by the unique ID from cbo_LL_Select, equal or greater thant the Start Date and Equal or Less than the end date and with Val being false.

Thank you for your help Mark
 

Part and Inventory Search

Sponsor

Back
Top