I have a form called frmSpecificDelivery. A user access this form to look at delivery information for each job. On this form is a command button called History. The user clicks this and opens a History form where they enter dates as the job travels through each department in our manufacturing plant. I would like to automate the status field on the main form.
If the user input a date for the prodction field, then the status on the main form should change from "In Layout" to "Ready for Production". I am not quite sure how to do this.
This is kind of where I was going but I keep getting an error.
Private Sub Command45_Click()
Call UpdateStatus
DoCmd.Close
DoCmd.RunCommand acCmdSaveRecord
Forms![frmSpecificDelivery].Requery
DoCmd.RunCommand acCmdSaveRecord
End Sub
Private Sub UpdateStatus()
If Me.Production Is Not Null Then
Forms!frmSpecificDelivery.Form.Status = "Ready for Production"
Else
End If
End Sub
If the user input a date for the prodction field, then the status on the main form should change from "In Layout" to "Ready for Production". I am not quite sure how to do this.
This is kind of where I was going but I keep getting an error.
Private Sub Command45_Click()
Call UpdateStatus
DoCmd.Close
DoCmd.RunCommand acCmdSaveRecord
Forms![frmSpecificDelivery].Requery
DoCmd.RunCommand acCmdSaveRecord
End Sub
Private Sub UpdateStatus()
If Me.Production Is Not Null Then
Forms!frmSpecificDelivery.Form.Status = "Ready for Production"
Else
End If
End Sub