ListBox refreshing after selection??

[Enviva]

Hi All,

I have a Listbox [ListRandom], that populates a random selection of employees. The listbox is set to "Multiple Select = Simple" What I have now is: I can select several employees and then click a [print] button, this prints an individual form with those employees information, and then adds them to a table [tblselected]. What I am trying to accomplish is After those employees are selected, printed, and added, I then want to go back to the random list to select the other employees, but I would like the first ones that were selected/highlighted to refresh and be gone, so that I dont accidently add the same employee twice.

Is this possible?
And can someone point me in the right direction.
thanks....Enviva

 

[seth_belgium]

This is an easy alternative to what you want:

In the table where you add your selected and printed employees, place your primary key on your employee-id (or any other unique field that identifies your employee).

That way you cannot add the same employee twice.

 

[Enviva]

Seth,
Thanks for your response, however, this is a random search, so the same employee could be selected next month, so he/she would need to be allowed to the database. (just not in the same day!) I was looking for away that would protect the end-user from double-entering.
Thanks....Enviva

 

[wkalo]

Hi

I Don't Really Know If What I Will Suggest Will Work Bit I Hope It Will.

In Your Table You Could Add A field YES/NO After Chossing Your Employee This Field Correcponding Chosen Employee Will Be Clicked To Yes. In Your Query To Display In List Box Under Field YES/No Choose =NO. Then When You Go Back For New Operation The Chosen Employee Will Not Be Shown But You Need After Each Operation To Refresh Data.

On The First Day Of Each Month You Could Assign An Update Query Where It Sets Field YES/NO To No. This Way All Employee Will Be Reselected In Your New Random Search In New Month.

I Hope It Will Work.