Printing A refport based on Form ID number

[dubmunkey]

Hi all,

Im trying to print a report from a form. I want the report to have the contents of the forms current record.

The underlying table has an autonumber as it's index/primary key and it's this im referencing. What happens is a record is saved and the autonumber is generated.


DoCmd.OpenReport stDocName, acPreview, , Me.RefID.Value ' the value of the forms id box

= [RefId]' the value on the report

The problem i have is this:

when i ask it to return the record which shares the id number of the current form record i get a blank report with no error.

when i ask it to return the record equal to a specific record number - by swapping the varibale for a fixed value i get all records- can anyone suggets what is going on here?

greg

 

[dubmunkey]

here is the code:

Dim stDocName As String
stDocName = "Referral Slip"
DoCmd.OpenReport stDocName, acPreview, , Me.RefID.Value = RepRefId

greg

 

[RuralGuy]

Try:
DoCmd.OpenReport stDocName, acPreview, , "[RefID] = " & Me.RefID

 

[dubmunkey]

cheers, i had put my quotes in the wrong place.

ta

greg