I have a form with an unbound combobox that has a manually list of integers that represent trip numbers - T_TN). When a user picks a number from that list, it executes "After Update" VBA that opens a report containing all information pertaining to that trip. Within that VBA, I have VBA statement that, also, gets the last trip's trip number - LT_TN.
I need a way that will enable me to compare the LT_TN with the list's last T_TN to update the list with all T_TN's between the list's last T_TN and the LT_TN, including the LT_TN.
I tried creating my own code, as well as, adapting several related examples that I found on the internet. I was unsuccessful, after spending seven 8 hour plus days, head banging and learning from the effort. So, as it has been in the past, I am, once again, asking for help from the wizards.
And 'Yes', I do like it here.
I need a way that will enable me to compare the LT_TN with the list's last T_TN to update the list with all T_TN's between the list's last T_TN and the LT_TN, including the LT_TN.
I tried creating my own code, as well as, adapting several related examples that I found on the internet. I was unsuccessful, after spending seven 8 hour plus days, head banging and learning from the effort. So, as it has been in the past, I am, once again, asking for help from the wizards.
And 'Yes', I do like it here.