Hi Macropod,

Could you please help me with the same code. In case I want to create a
result sheet but don't want a student to see other student's marks.

So, how can I add different passwords for different students.

Are you trusting that the students won't share passwords?

Instead of a 'results sheet', why not just display the results for the student
in a msgbox -OR- a designated field on the form where the StudentName:Password
gets input?

Otherwise, explain how you want this 'results sheet' approach to work!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion