Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Continuous Form Problem

Status
Not open for further replies.

DeeDee

Programmer
Jul 13, 2000
34
US
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
 
Check your form properties. You need to be sure "data entry" is set to "no." Otherwise, I'm not sure.
 
That Worked!!! You saved me from a break down(ha-ha)!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top