Search results

Thanks for approving. You say it can be for example "on enter"?

Is there any simple solution to make it work when calling from the main form? I will not need it from the subform as well. I will need it only from the main form, but I wanted to confirm that, as it is now, works from the subform. Thank you.

Thank you Accessing for the detailed explanation. When I do as you have said I get an error: "Compile error: Invalid outside procedure" I added this code Forms!FormName!ChildName.Form.Form_AfterDelConfirm(Status) Forms!FormName!ChildName.Form.Form_BeforeUpdate(Cancel) on the top of the code...

Thank you Accessing for detailed instructions. I just tried to follow steps that you wrote and I get an error "Invalid outside procedure" and (Status) gets highlighted. I think you are very near the solution to my problem, there is just some detail missing here.

Thank you Galaxiom! I tried to change it to Public Sub but that did not resolve the issue. Also, I tried to follow your explanation but I am not sure if I understand everything as I am quite a beginner. However, this is the exact code that I used: fontstuff.com/access/acctut21.htm and applied to...

Hi guys I am trying to track changes to my tables and I hit the wall. I have this code in my modules: Sub AuditChanges(IDField As String, UserAction As String) On Error GoTo AuditChanges_Err Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim ctl As Control Dim...