i need to link the planning worksheet to auto fill from the order master. right now i have user typing in order number but would like to somehow link the me.[order number] from the form to the report
Code:
Private Sub Planning_Work_Sheet_Click()
On Error GoTo Err_Planning_Work_Sheet_Click
Dim stDocName As String
stDocName = "Planning Work Sheet"
DoCmd.OpenReport stDocName, acPreview
Exit_Planning_Work_Sheet_Click:
Exit Sub
Err_Planning_Work_Sheet_Click:
MsgBox Err.Description
Resume Exit_Planning_Work_Sheet_Click
End Sub