I made a popup form, for when a user change the value of a field, the window opens automatically.
I created a new table: comments and also audit tables of the same table.
I did one to many relationship, for TblPassosStatus TblComentários.
In the event the change of the field, put the following code:
DoCmd.OpenForm "fComentários",, "CodPassosStatus =" & Me.CodPassosStatus
Opens normally, but the tables are not relating.
I need a text box to show all the comments field change, the date when the user selects a particular step. I tried another sub sub. It did not work.
I still have doubts if necessary, create the audit tables for table comments. For comments, can not be changed. I did the audit table in order to display the comments in the text box.
I tried putting the following code to load in the event of the form for comments:
Me.formComentarios = now ()
It worked, but the date is not locked. If I could get the date it locks. I do not need the audit tables. For when you place the text box to display all comments for a particular step, they would already be with the dates.