I am working on one production software, I want to place work order and then once the system gets message that " work order has been Placed" i want to display a message asking user " if you like to print that work order"
How would i do thata straight from the form , wihtout going to the report?
I want to print wihtout going to report.
Thanx in Advance.
Set adrsRWOID = curdb.OpenRecordset("Select * from [Manual Ripped Work Order]")
adrsRWOID![Manual Work Order ID] = Form![Manual Work Order ID]
adrsRWOID![Manual RWO Date] = Date
adrsRWOID![Item Number Ripped] = Form![Recipe Item Number]
adrsRWOID![Description] = Desc
adrsRWOID![Quantity to produce] = formname![Quantity to produce]
adrsRWOID![Item Number] = Form![Item Number]
adrsRWOID![Description Finished] = Form![Description]
If Not IsNull(Form![Instructions]) Then
adrsRWOID![Instructions] = Form![Instructions]
Debug.Print adrsRWOID![Manual RWO ID]
response = MsgBox("Manual Ripped Work Order Has Been Placed,Would You Like To Print Ripped Work Order?", vbYesNo, "Placing Ripped Work Order")
If response = ID_YES Then
DoCmd.OpenReport "Manual Ripped Work Order Report", acNormal, , "[Manual RWO ID] = " & adrsRWOID![Manual RWO ID]