koolwaters
Active Member
- Joined
- May 16, 2007
- Messages
- 403
Hi!
I have a form that is used to log issues that a client has. This form contains a subform which links an issue with the actions associated with that particular issue. One issue can have many actions hence the subform. I have a button on the main form which is used to print the current issue and any related actions. The report contains a textbox with an overall running sum to number each action of that particular issue. This works perfectly.
I also have a button on the subform to print the selected action on the subform. I use the criteria stCriteria = "[IssueActionID]=" & Me.IssueActionID to preview the report for that particular action. This works with the exception of my running sum.
Lets say IssueID 1 has 5 associated Actions. Depending on when the associated Action was created, the ID field is not always consecutive. For example ActionID 1 may have related IssueActionID 1, 2, 3, 4, 7 and IssueID 2 may have IssueActionID 5,6.
Let's say I want to print the the last action for IssueID 1, when I print the report, I want to see 5 for the numbering, as that is the 5th action of that item. With the running sum, what I am getting is 1 for the numbering.
Any suggestions?
Thanks in advance for any assistance.
I have a form that is used to log issues that a client has. This form contains a subform which links an issue with the actions associated with that particular issue. One issue can have many actions hence the subform. I have a button on the main form which is used to print the current issue and any related actions. The report contains a textbox with an overall running sum to number each action of that particular issue. This works perfectly.
I also have a button on the subform to print the selected action on the subform. I use the criteria stCriteria = "[IssueActionID]=" & Me.IssueActionID to preview the report for that particular action. This works with the exception of my running sum.
Lets say IssueID 1 has 5 associated Actions. Depending on when the associated Action was created, the ID field is not always consecutive. For example ActionID 1 may have related IssueActionID 1, 2, 3, 4, 7 and IssueID 2 may have IssueActionID 5,6.
Let's say I want to print the the last action for IssueID 1, when I print the report, I want to see 5 for the numbering, as that is the 5th action of that item. With the running sum, what I am getting is 1 for the numbering.
Any suggestions?
Thanks in advance for any assistance.