historical dates for

[June7]

I just noticed the Contador field is text type. Count is a number value.



You want to show just the count or the full records from audit table?

To show just the count, can use DCount function in a textbox on form that will count the audit records. If you want to view the records, use code in some event to open a form filtered to the related records. You want the form locked up so users can't change the entries. Allowing changes would defeat purpose of an audit trail. If you need help with problems you encounter for this new effort, start a new post and we can show this one as solved.

[fabiobarreto10]

Perfect, I thought I had no difference, because text can store numbers, but I'll change.
For example, when you click on the subform on top of the rescheduled date of a particular step, I can visualize in a text box, the history of who changed, time and date, and all historical values​​. I just need to see in the text box field history rescheduled date, others are not needed. Yes, and only to view, can not be edited. I'll post a new topic. I could not identify where in March the threads as solved. I mark this as much as before.

[June7]

Using textbox would require concatenation of fields from multiple records. Need VBA code. I often use a locked listbox to display records for information only. The RowSource would be SQL that queries the audit table with filter criteria of the step ID from the current record on form.

Yes, the text field will take the number value but the data will be treated as text for purposes of search and filter. Which means in an alpha short 10 will sort before 2.

The Thread Tools dropdown at top of thread has option to set thread as solved.

[fabiobarreto10]

June7,
I marked all my posts as solved.
In this case, the list box. Not many columns to display in a list box?
Can I put this message in a new topic I created?

[June7]

I am now responding in your new thread.

[fabiobarreto10]

Ok. Tanks!