<div>
Why not use the On Change or After Update Event on the first Textbox to set the second Textbox to null, and vice versa?
</div>


<div>
after update will save the form.<br />
when i use on change it will change the value of the control. but user will still see the previous value in the screen..it will not refresh the form to show you the null value .
</div>


TexboxDemo.zip

drtopserv

<div>
If you want to not save the record..just use 2 Unbound text boxes...use the After Update to toggle the text and use some other method to push the value to the underlying fields
</div>


President / Owner CARDA Consultants Inc.

Daniel Pineault

<div>
<div class="content wysiwyg-content">
Hi,<br />
I have 2 textboxes in main form.<br />
<br />
what i want is:<br />
<br />
Every time i write in textbox 1, I want textbox 2 to get a NULL value and vice versa.<br />
The action I did is via the IF command, only the problem is that textbox 2 is getting the value NULL, but it doesnt displayed in the form (not refreshed).<br />
How can I refresh textbox 2 without saving to form.
</div>
</div>


Hi,
I have 2 textboxes in main form.

what i want is:

Every time i write in textbox 1, I want textbox 2 to get a NULL value and vice versa.
The action I did is via the IF command, only the problem is that textbox 2 is getting the value NULL, but it doesnt displayed in the form (not refreshed).
How can I refresh textbox 2 without saving to form.

refreshing textbox value in access form without saving the record

ms access forms

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.