Quote:
Originally Posted by Johnymap
Thanks nathj
unfortunatelly I am not allowed to use a database for this matter, its just some co. policy. So, do you have some code that i can use to solve this. i have looked almost everywhere for help but nothing seems to be helping.
Please help
Hi Johnymap,
Sorry for the delay in geting back to you - been busy with work.
If you have to use text files and arrays then it would seem that you need to develop a loop through the array. So that when a user selects the item from the dropdown list you loop through the array from start to finish and return the last matching item.
So if you find a matching itme you store that in a variable and then continue with the loop. By the time the loop completes you will have the latest item for that year in a variable and you can then write that variable as the value to a text box or simply to the screen.
This of course assumes that the array is in the order oldest to newest.
I hope this helps, I'm sorry i haven't time at the moment to write any code for you.
Cheers
PS It may be easier to change company policy - I know I did that once and life is better for it.