Access 2000 Forms

[AcornD]

How do you create a button on an access form to print/ preview only the current record

Ie the record that i am working on and not all the records in the database.

 

[Remou]

Use the Where argument:

[tt]DoCmd.OpenReport "rptReport", , , "ID=" & Me.ID[/tt]

 

[AcornD]

Have Type above and keep getting a compile error
Method or data member not found

DoCmd.OpenReport "report10", , , "ID=" & Me.ID

and it always highlights the .ID

 

[Remou]

I do not know what your fields and controls are, so ID is a generic name for an ID field and Me.ID is the matching control on your form. In addition, the example is for a numeric field. A text field would require single qotes.