thank you very much sir
it works great now

in the future it would be more helpful if you gave examples of code, but nonetheless you're very helpful indeed

one problem i faced:
it was doubling null fields in the listbox when I generated the student report so i added an if statement to check for null before output