Filter by multiple fields or Create a duplicate record but exclude certain fields?

[Shane van Heerden]

Table Fields: ID, Route, Flight1, NewDate1, Flight2, NewDate2, Surname, TagNumber etc.

Form Filter Code:

If Not IsNull(Me.txtStartDate) Then
strWhere = strWhere & "([NewDate1] >= " & Format(Me.txtStartDate, conJetDate) & ") AND "
End If
If Not IsNull(Me.txtEndDate) Then
strWhere = strWhere & "([NewDate1] < " & Format(Me.txtEndDate + 1, conJetDate) & ") AND "
End If

I need to filter/search by both NewDate1 and NewDate2?

Or maybe a totally different approach? Create a duplicate recordset with first record containing Flight1 and NewDate1 and the second record Flight2 and NewDate2 data?

Any help appreciated :o)

[NeoPa]

I think you'll find all the detail you need in Cascaded Form Filtering.

[Shane van Heerden]

Thanks NeoPa. Will check it out the link...

Your assistance is appreciated

[NeoPa]

Glad to help Shane :)

Welcome to Bytes!