Filter vba problem

[Moss100]

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

 

[Andrzejek]

Select ...
From ...
Where UniqueID = cbo_LL_Select.Value
And StartDate Between txt_DateStart And txt_DateEnd
And Val = chk_Val.Value