I have a subform (TabEmployee) with a command button on it that opens another form called Milestones which is based on a table called MilestoneData and is set to Continuous Form. TabEmployee is based on a table called TaskData which has some of the same fields as Milestone data. What I'm doing is checking a mutual field (TaskID) and where they are the same in both tables, the records should appear in the Milestones Form. The records are in the table, but when I click the command button and Milestones opens, there are no records in it. Thanks for any help in advance. Here's a little of my code from Milestones:
Private Sub Form_Open(Cancel As Integer)
If Me.NewRecord Then
Me.TaskID = Forms!Main!TabEmployee!TaskID
Me.ID = Forms!Main!TabEmployee!ID
Me!ReportDate = Forms!Main!TabEmployee!ReportDate
Me!OriginationDate = Date
Me.ActionRequestNumber = Forms!Main!TabEmployee!ActionRequestNumber
End If
Private Sub Form_Open(Cancel As Integer)
If Me.NewRecord Then
Me.TaskID = Forms!Main!TabEmployee!TaskID
Me.ID = Forms!Main!TabEmployee!ID
Me!ReportDate = Forms!Main!TabEmployee!ReportDate
Me!OriginationDate = Date
Me.ActionRequestNumber = Forms!Main!TabEmployee!ActionRequestNumber
End If