Apologies, maybe I am not explaining it properly!
The user enters the order details into a form, and once happy there is a button to submit authorisation email. This opens a report (because the report and form are different layout), currently as the report is based on a query, it asks the user to enter the order ID for which the report should be opened. What I want is the ID the form was open at, to be used when opening the report. I have got a little further with the below, however my understanding is open report with preview was without it printing it. The below code is still looking to print the report:
Code:
Dim strWhere As String
Dim DocName As String
DocName = "ID: Overview"
strWhere = "[ID]='" & Me.ID & "'"
DoCmd.OpenReport "Sample Order Form", acViewPreview, , strWhere
Going into debug mode, acviewpreview value is 2 and strwhere is 3 (which is the correct id - correct record I had opened in my form)
Hope this makes sense, I am close (I think) and thank you so much for your time, really appreciated.