Search results

Is it possible to pass variables between Private sub routines (modules) and functions? I've tried declaring variables as public and setting the value to the value of a field on a Form BeforeUpdate, but when I try to use them in a Private sub or Public Function the values are lost. For example...

:confused: Anyone know how to trap/prevent the msg "The DoMenuItem action was cancelled" after answering no to deleting a record? I followed the instructions at the following thread but no luck...

The code below is from a form named frmWorkorderComplete I use to append the tblWorkordersComplete table with data from the fields in the table tblWorkOrders. I'm trying to prevent duplicate entries in the tblWorkOrdersComplete table. To do this, I create a unique identifier for each record to...