Selection and Unselection of Subjects in a better way (1 Viewer)

[a_20120]

Hello all, about few months ago, I posted the problem here, and Mr. MsTef, has helped me much.

Details:
there are two list boxes, one has the subjects that the student can select, and one has the selected sunjects of the student, if a student want to select or unselect a subject jsut double click on the lsit box.

Wanted:
but now I want the selection and unselection of the student done in a better way, for more info see the attachment, there mentioned what I want

 

[MStef]

Hello Ab_Rahman!

Here it is.
I have arranged "frmStudentSubjectSelection"
I have added "qryStcode", "NoMatching", "qryDeleteAll", "qryAppendAll".

 

[a_20120]

Thanks Much, MsTef

Thanks for replying
when you click on the link, another form appears, I like what you did, on that form exactly, I mean instead the first form, I want to do everything on second form which open by link.
Hope can express what I want...

 

[a_20120]

Hi.
Is it possible to do the above attachment example, through VBA and SQL coding, not through using QUERIES? if yes, plz do in coding some one