Recent content by Dom Fino

I have been adding this audit trail to my application with some of the modifications suggested by others on this thread. The audit trail works great on one form but I receive a compile error when I try to add the functionality to another form. I receive an error: Compile Error Invalid use of...

GHudson, Thank you so much. I did as you suggested and it works perfectly. Thank you again for creating such a useful tool. Merry Christmas and have a safe and healthy New Year. Dom

G Hudson, I have found this post to be very helpful. It has certainly made this newbie's job much easier. I have successfully incorporated your code plus the edits from Lyn Mac. Now I want to make one more modification but need some help. I want to hide the text box on the forms and...

Wayne, Your suggestion fixed the problem regarding (Enter Parameter Value). Thank you. However, If I put a check in the box (add to the table) I receive this error. When I check the actual table the record is there. Error No 3022 Description: The change you requested to the table were not...

Hi Wayne, Thanks for your reply and code example. Unfortunately, when I run the code I get a pop up asking me to Enter Parameter Value - (it shows the actual last name). Example: Enter Parameter Value 'Smith' When I first start the application and enter a check in the box I get error 3075...

I have a main form that has a check box. If the check box is checked, the on_click option is to determine if the current record ID exists. If the current record ID does not exist, then insert data into a Lost_LKU table. If the check box is unchecked, the on_click option is to delete data from...