I have created Allen Browne search criteria form. In the main form, there are many field like text, number, currency and Year. Year is selected by drop down combobox in the following vba and works fine.
Dim strYears As String, intCounter As Integer
For intCounter = 0 To 20
strYears = strYears & Year(Date) - intCounter & ";"
Next intCounter
strYears = Left(strYears, Len(strYears) - 1)
Me.PurchasedYear.RowSourceType = "Value List"
Me.PurchasedYear.RowSource = strYears
The problem is I have no idea how to write vba to filter criteria;
1) in between two years.
2) criteria in between two currency values
3) criteria in between two number fields
Any help for the above is highly appreciated.
Buddhika
Dim strYears As String, intCounter As Integer
For intCounter = 0 To 20
strYears = strYears & Year(Date) - intCounter & ";"
Next intCounter
strYears = Left(strYears, Len(strYears) - 1)
Me.PurchasedYear.RowSourceType = "Value List"
Me.PurchasedYear.RowSource = strYears
The problem is I have no idea how to write vba to filter criteria;
1) in between two years.
2) criteria in between two currency values
3) criteria in between two number fields
Any help for the above is highly appreciated.
Buddhika