J
Jet
I have a "Deliverables" form. Each deliverable has a command button to open
a "Tasks" form (that shows all the tasks for the particular deliverable -
Each task record has the associated deliverable ID number ). The code for
this command is:
Private Sub Command15_Click()
On Error GoTo Err_Command15_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmTasks"
stLinkCriteria = "[Deliverable ID]=" & Me![Deliverable ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command15_Click:
Exit Sub
Err_Command15_Click:
MsgBox Err.Description
Resume Exit_Command15_Click
End Sub
The problem is when I create a new deliverable and click on the button, the
deliverable id number is 0 not the associated deliverable ID . How can I
have the number transfered over on new task records.
Thanks
a "Tasks" form (that shows all the tasks for the particular deliverable -
Each task record has the associated deliverable ID number ). The code for
this command is:
Private Sub Command15_Click()
On Error GoTo Err_Command15_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmTasks"
stLinkCriteria = "[Deliverable ID]=" & Me![Deliverable ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command15_Click:
Exit Sub
Err_Command15_Click:
MsgBox Err.Description
Resume Exit_Command15_Click
End Sub
The problem is when I create a new deliverable and click on the button, the
deliverable id number is 0 not the associated deliverable ID . How can I
have the number transfered over on new task records.
Thanks