Passing Data between Forms and being able to save data changes

[MeekoRayne]

Good Morning,



I created a Database of co-workers and Tasks. I have a form of task details.. I have another form that lists all of the tasks. What I want to do is make a selection from the Task List where it will then take me to the form of the task details and I can also make changes to that task. I've been able to implement an method OpenArgs statement within those forms, however I'm not able to save the update since the text boxes are no longer linked to the corresponding table. Can anyone help me with this issue?

[ranman256]

the list of tasks would have a button on the form header.
clicking it would grab the key of the record the cursor is on to open the detail form.

sub btnDetail_Click()
docmd.openform "fTaskDetail",,,"[TaskID]=" & me.TaskID
end sub

[MeekoRayne]

This is what I have a originally.

(Task Lists Form)
Private Sub txtOpen_DblClick(Cancel As Integer)
If Me.NewRecord Then 'open form without passing anything in OpenArgs
DoCmd.OpenForm "frmTask"
Else 'pass ID Info and name in OpenArgs
DoCmd.OpenForm "frmTask", , , , , , Me.ID & ";" & Me.Task & ";" _
& Me.For & ";" & Me.AssignedTo & ";" & Me.StartDate & ";" & Me.EndDate & ";" _
& Me.CompDate & ";" & Me.CompBy & ";" & Me.Priority & ";" _
& Me.Description & ";"
End If

(Task Details Form)
Private Sub Form_Load()
Dim strOpenArgs() As String


If Not IsNull(Me.OpenArgs) Then
strOpenArgs = Split(Me.OpenArgs, ";")
Me.txtID = strOpenArgs(0)
Me.txtTask = strOpenArgs(1)
Me.txtFor = strOpenArgs(2)
Me.txtAssignedTo = strOpenArgs(3)
Me.txtStartDate = strOpenArgs(4)
Me.txtEndDate = strOpenArgs(5)
Me.txtCompDate = strOpenArgs(6)
Me.txtCompBy = strOpenArgs(7)
Me.txtPriority = strOpenArgs(8)
Me.txtDescription = strOpenArgs(9)
Else
DoCmd.GoToRecord , , acNewRec
End If