Ok here it is.
I have a data base that will keep track of our sales reps yearly sales totals in dollars.
I have a multitab form.
one of the tabs has a subform in it that is keeping track of this.
I have a drop down listing various years from a basic table.(1993-2003)
That is being put into another table under the employees unique ID that Access created when I set the person up and is used through out the programfor filtering purposes as you know.(NOT their employee number)
Underneather that dropdown of years I have a box where they enter the total for the selected year.
I press a button and it ads it to a list in that subform.
That sublist gets requeried.
However the tough part is I dont want duplicate years for that individual.
I would like to have that year dissappear off the drop down if possible. Or else update that year with the new value if need be. Whichever is easier. Either way I dont want the same year twice in the list box.
I I then want to be able to select one from the list and either delete it or change it. I cant figure that out though.
After this is all said and done, I would like to have all these totals added up and displayed in another textbox. I cant figure out how to get a total displayed. Im quessing a query.
Thanks for the help.

Jon
I have a data base that will keep track of our sales reps yearly sales totals in dollars.
I have a multitab form.
one of the tabs has a subform in it that is keeping track of this.
I have a drop down listing various years from a basic table.(1993-2003)
That is being put into another table under the employees unique ID that Access created when I set the person up and is used through out the programfor filtering purposes as you know.(NOT their employee number)
Underneather that dropdown of years I have a box where they enter the total for the selected year.
I press a button and it ads it to a list in that subform.
That sublist gets requeried.
However the tough part is I dont want duplicate years for that individual.
I would like to have that year dissappear off the drop down if possible. Or else update that year with the new value if need be. Whichever is easier. Either way I dont want the same year twice in the list box.
I I then want to be able to select one from the list and either delete it or change it. I cant figure that out though.
After this is all said and done, I would like to have all these totals added up and displayed in another textbox. I cant figure out how to get a total displayed. Im quessing a query.
Thanks for the help.

Jon
Last edited: