I track all projects in our department and their time line. A project can be in 1 of 4 stages: Idea, Development, On Going, and Complete. These are in an option group stored in StatusDescription. Associated with each option is a separate date field named: IdeaDate, DevelopmentDate, etc. In the report, bound to a query, I group projects based on StatusDescription. In the detail section there is an unbound textbox named RefDate. I am trying to populate RefDate based on StatusDescription. Here is what I tried. The row source for RefDate is blank. Any help would be appreciated.
Code:
Private Sub Detail_Format(Cancel As Integer)
If StatusDescription = "Idea" Then
IdeaDate = RefDate
ElseIf StatusDescription = "Development" Then
DevelopmentDate = RefDate
ElseIf StatusDescription = "On Going" Then
OnGoingDate = RefDate
ElseIf StatusDescription = "Complete" Then
CompleteDate = RefDate
End If
End Sub