help me pls. Access 2003 Query and vb code on access 2003

[_g3o_]

i have two problems on access 2003 and i want your help, the first one i want the Private Sub of my form, named form, that when i opening it i want to checking something with an if statement.

the code is this?

Private Sub form()

do this etc etc

end sub

?

the second question is. i have a a table name attachments. and inside i have the fields, users_id, name, surname, cv_attachment (which is yes/no), exam_results_attachment (yes/no) , other_attachment (yes/no) . Now on the following table i have insert this data : 1 , george , kyriacou , yes , no , no

and what i want is to create a query showing me only the user id, name, surname and fields that have only the result no. in this case the fields that i want are the user_id,name,surname,exam_result_attachment,other_attachment.

how i can do this?

thank you