[AccessD] Opening report on desired record

Hey Group

I have a form that opens report, and I'd like it open on the record thats
selected on the form. Bith are coming from the same table. How can I do
that ? (i am in access97)
textbox is called employeenumber



 Dim stDocName As String

    stDocName = "Carol"
    DoCmd.OpenReport stDocName, acPreview
    where stDocName![employee name] = Me.employeenumber.Text


-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail