Access 2007: I have a form with a combobox that is configured as value list. I want to pick a trip number (ie., D_TN) from the list, like trips 1 thru 10, and open a report.
I, also, have a query that contains the leg numbers for each trip, like: 3.01, 3.02, . . . . 3.05., which are all under trip 3, where D_TN = 3.
I already have written afterupdate code that gets the max & min leg numbers after a trip number is selected, which for this example are maxT_TN = 3.05 & minT_TN = 3.01.
I need help with the code that uses those three parameters and opens a report displaying only the records for the selected trip number, 3 for this example.
I know how to do that for date ranges, from Allen Browne's paper, but couldn't get a variation of it to work.
I, also, have a query that contains the leg numbers for each trip, like: 3.01, 3.02, . . . . 3.05., which are all under trip 3, where D_TN = 3.
I already have written afterupdate code that gets the max & min leg numbers after a trip number is selected, which for this example are maxT_TN = 3.05 & minT_TN = 3.01.
I need help with the code that uses those three parameters and opens a report displaying only the records for the selected trip number, 3 for this example.
I know how to do that for date ranges, from Allen Browne's paper, but couldn't get a variation of it to work.
Last edited: