subform and Report

[Abdulaym]

Trust we are all doing great?


I have the following
Report Name= rpt_invoice
Subform name/source object= frmSales
Form record Source= tblCusromers

I want my report to display the current Customer_ID in my form in my Report so as to print it out. the below codes was used but I keep on getting error msg. please am new in ms access. I really need help

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "rpt_invoice", acViewPreview, , "[Customer_ID] = " &
[Customer_ID]

Thanks

[Micron]

All that stuff at the beginning looks like you are thoughtful about some details. This is of no help at all

I keep on getting error msg.

Provide the error number and/or description (never just the error number). If you show code about an error make sure you identify the line that causes the error. Now to your question:
Is Customer_ID text data type or is it number data type? If text, try
DoCmd.OpenReport "rpt_invoice", acViewPreview, , "[Customer_ID] = '" & [Customer_ID] & "'"

[Abdulaym]

Thanks for your response sir
The Customer_ID is AutoNumber sir

when I typed my code the second line display error like this:

Compile error:
Expected: Expression

[Micron]

I wouldn't use line breaks in case there's an unwanted space in your code, or at least I'd copy and paste into code tags here. If there are any extra spaces, the forum would likely strip it out when not in code tags and we wouldn't see it as a problem. Since you say that CustomerID is an autonumber, all I can suggest is to try
DoCmd.OpenReport "rpt_invoice", acViewPreview, , "Customer_ID = " & Customer_ID

Note that I also eliminated the brackets. Don't have time to check now but they may be causing your field name to be interpreted as [Customer_ID] and not Customer_ID. You don't need them anyway because there are no spaces in your field name.