I have spent 4 hours browsing the forums. I've copied my own previous code and still get this error message:

Extra )in query expression '(EquipmentID=)'.

All i'm trying to do is print a single report based on the form i have open and using the 'EquipmentID' field to ensure that just this one alone prints.

This is my present code on the OnClick Event of a command button:

DoCmd.OpenReport "DivingInspectionCert", , , "[EquipmentID] = " & Me!EquipmentID

Thank you very much in advance

Ok Guys,

I think i've solved it by finding a piece of code from a similar post by Rural Guy:

DoCmd.OpenReport "DivingInspectionRpt", , , "[EquipmentID] ='" & Me!EquipmentID & "'"

Just got to solve another wee problem but i think this works now.
If not i'll let you know here.