Hi LilBomShl,
Yes, you can. Set the query powering the report so that it picks up the ID
of the record off the form, like this:
select * from TABLENAME where IDFIELD = forms!FORMNAME.IDFIELDNAME
Then use the following in the on click event of the command button:
docmd.openreport "REPORTNAME", acViewPreview
Hope this helps.
Damian.