C
CJ
Hi Groupies
I am using A2K7
I have an unbound form that is used to set up a new service ticket. They
select from an existing job and then they enter a date and ticket
number.Then the user pushes a button and the new service ticket is created
based on the input data.
My problem is this:
The new service ticket is on a subform of the job form. I can get the
correct job to open up and show it's existing service tickets, but I don't
know how to tell the subform to go to a new record and make the ticket
number and date equal to what was on the input form.
At the moment I have the following code on a button on the input form:
Private Sub cmdNewMLT_Click()
DoCmd.OpenForm "frmOpJobMLT", acNormal, , , , , "JobNumber =
Me.cmbJobSearch'"
End Sub
I am using A2K7
I have an unbound form that is used to set up a new service ticket. They
select from an existing job and then they enter a date and ticket
number.Then the user pushes a button and the new service ticket is created
based on the input data.
My problem is this:
The new service ticket is on a subform of the job form. I can get the
correct job to open up and show it's existing service tickets, but I don't
know how to tell the subform to go to a new record and make the ticket
number and date equal to what was on the input form.
At the moment I have the following code on a button on the input form:
Private Sub cmdNewMLT_Click()
DoCmd.OpenForm "frmOpJobMLT", acNormal, , , , , "JobNumber =
Me.cmbJobSearch'"
End Sub