I got it working but I lost some functionality that I built (from a tutorial).
My new function is as follows:
Code:
Function getOpenStatus() As String If Me.Private_TRUE = False And Private_STATUS <> "DISPOSITIONED" Then
getOpenStatus = "Open"
Else
getOpenStatus = "Closed"
End If
End Function
This is now populating a continuous form with Open or Closed, thank you for your help! However, it only populates the visible 'cells' until I scroll up, which I could live with but the functionality that I lost was the ability to sort by clicking on the header.
My code for doing this was in the "On Click" event:
Code:
Private Sub OpenStat_Label_Click()
If OrderBy = "OPEN_STATUS" Then
OrderBy = "OPEN_STATUS desc"
Else
OrderBy = "OPEN_STATUS"
End If
End Sub
Now that it is a calculated field, this sort doesn't work. Is there a work around?
Other info: I arrived at this because a previous iteration of this form wouldn't accept input and was displaying "This Recordset is Not Updateable", which I think was because I was using multiple sources to populate that form. I realize that there are a lot of reasons that can happen so I started over, only using DLookup to reference other tables. BTW, I can't "column sort" the fields built with DLookup either, but one problem at a time!