Ok, so that did break other things in the form that I didn't think would be affected by this code. So let me expand on what I'm wanting to do.
I changed the data type of the ID field because I want to be able to enter the ID in this manner 2019-01, 2019-02, 2019-03. The expression in the form tracks the history of comments that you enter in a comment box and I want to maintain that functionality. So how can I retain the comment history tracking...
User Profile
Collapse
-
-
Thanks I'll give that a shot.Leave a comment:
-
Modify Control Source Expression for change in field type
I'm using the access template for Issue Tracking and making small modifications for my needs. One thing I did is change the ID field type from a number to a text and when I did that the below expression in one of the forms will no longer work:
How can I modify this so it works with the "ID" field being text now instead of a numb...Code:=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
No activity results to display
Show More
Leave a comment: