a tough list box question. I bet you can't figure it out!

JonatABS

Registered User.
Local time
Yesterday, 23:22
Joined
Dec 16, 2002
Messages
114
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
 
Last edited:
To see Years without duplicate use
"Select Distinct Years from TableName" in your ListBox RowSource.
 
Problem with that is the row source has the queryname in it.
 
Change the start of your query to include 'DISTNICT" statement.
 

Users who are viewing this thread

Back
Top Bottom