Greetings.
I have a an access database used to track a process. For simplicity, let's say it is a three step process and three things are tracked: when the product was received, when it was shipped, and a tracking number. Two are date fields: [ReceivedDate] and [PackageFWD] and one is a text field [TrackingNumber].
I am trying to incorporate a feature into a report whereby I could have an unbound field ([ProcessStep])identify at which point in the process the item is currently at.
Here is what I've tried so far, to no avail:
Code:
Private Sub Report_Activate()
If IsNull(ReceivedDate) = True Then
Me.ProcessStep = "Awaiting Received Date"
ElseIf IsNull(PackageFWD) = True Then
Me.ProcessStep = "Awaiting PackageFWD"
ElseIf CertificateNumber = "" Then
Me.ProcessStep = "Awating Certificate Number Assignment"
Else
'Do Nothing
End If
The report has multiple rows. I have had luck with the updating on the ReceivedDate, but it seems to update the field for all records (including those that have a date in the ReceivedDate field). Seems like it is all or nothing and unable to differentiate between records.
I should reference that the query behind the report uses a Nz() function on the dates to return a 0 value.
Any thoughts/suggestions?