im sorry for asking the same question again but cannot solve my problem. all i want to do is print of the current record as report using a command button. there MUST BE some clever sod out there who can help. PLEASE DONT IGNORE ME. HELP. (oh im a novice at vb)

Look up the OpenReport Method in help for syntax.

You can refer to the key fields from your form to specify the where clause for the OpenReport Method.

The syntax for referring to a control on a form is:
FORMS!yourformname!yourcontrolname