Current Value Previous Field Value. Ever wonder why it is so difficult to figure out what the original value of a form field was after the user updates the field I thought that the Before Update event would help me do this but using the Me. Fieldname. Oldvalue doesnt give me the old value it gives the new value Here is a simple way to do this  First set up a global variable in this form just after the Option Compare Database. In this example we dimension a string variable called holdvalue. VBA Excel and VBA Access training courses in London or at your offices UK wide. Learn to program macros. Small classes. 50,000 testimonials. Sending Microsoft Access Email Blasts Programmatically VBA The addin Wizard in Total Access Emailer lets you interactively create the email blasts you want to send. Microsoft Excel VBA. Below are archived posts from the MrExcel Message Board about Microsoft Excel VBA. You will find lots of tips and tutorials for using visual. Sony Vegas Pro 9 Keygen Only Downloads. Blue Claw Database Design is your premier source of Microsoft Access programming and database support. Both small business and department level databases. Desktop installation as well as cloudinternet based solutions. Option Compare Database   Dim holdvalue As String. Next we create an On Current event for the form Private Sub FormCurrentholdvalue Me. End Sub. You may find that you get a null value error so you might want to use the following assignment to get around this little problem holdvalue NzMe. FzVI7UYSD6E/TmQgmGgxAmI/AAAAAAAAAFE/JGaPxuZxzPU/s1600/Variable-not-defined.png' alt='Microsoft Access Vba Option Compare Database Visual Basic' title='Microsoft Access Vba Option Compare Database Visual Basic' />Finally in the After Update event we have both the new and old values available for us to use Private Sub icountAfter. UpdateMsg. Box holdvalue Me. End Sub. It may also be useful to use this technique in the Before Update event. VBA Global Variables ProgramWide Data Storage. VBA Global variables are a powerful feature in Microsoft Access. There are two levels of these Visual Basic global. Access database calculations compare old vs new form field values. Compare two Access databases or two versions of the same database, including changes in tables, queries, reports, and VBA code.