Now, when a value of 1 is entered in Textbox1, Textbox2 will automatically be populated with a value of 10. If problems with MS Access have caused the database (.ACCDB/.MDB) files to turn corrupt or inaccessible, you can try using a professional Access file repair and recovery tool to regain access to the files and data. Then place the following code: Private Sub Textbox1_AfterUpdate() Summary: This post will outline several common issues Microsoft Access users have reported after Windows 10 update.It will also provide workarounds to fix those issues. When the Choose Builder window appears, highlight Code Builder. A button with 3 dots to the right should appear. Click on the property called 'After Update'. To do this, open your form in Design View. Question: In Microsoft Access 2003/XP/2000/97, what VBA code do I use to set the value of a textbox based on the value of another textbox?įor example, if someone enters a value of 1 in Textbox1, then I want to set Textbox2 = 10.Īnswer: To set the value of Textbox2 based on the value entered in Textbox1, you need to place your VBA code on the 'After Update' event of Textbox1. This MSAccess tutorial explains how to set the value of a text box based on the value of another text box in Access 2003 (with screenshots and step-by-step instructions). Hello all, Ive made it so that my form refreshes after any updates to any of the records on my continuous form occur.

MS Access 2003: Set the value of a textbox based on the value of another textbox

Microsoft access after update