By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,997 Members | 1,470 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,997 IT Pros & Developers. It's quick & easy.

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

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

Form Filter Code:
Expand|Select|Wrap|Line Numbers
  1. If Not IsNull(Me.txtStartDate) Then
  2. strWhere = strWhere & "([NewDate1] >= " & Format(Me.txtStartDate, conJetDate) & ") AND "
  3. End If
  4. If Not IsNull(Me.txtEndDate) Then
  5. strWhere = strWhere & "([NewDate1] < " & Format(Me.txtEndDate + 1, conJetDate) & ") AND "
  6. 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)
Sep 8 '10 #1

✓ answered by NeoPa

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

Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,429
I think you'll find all the detail you need in Cascaded Form Filtering.
Sep 8 '10 #2

P: 4
Thanks NeoPa. Will check it out the link...

Your assistance is appreciated
Sep 9 '10 #3

Expert Mod 15k+
P: 31,429
Glad to help Shane :)

Welcome to Bytes!
Sep 13 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.