[Last Call] Learn how to a build a cloud-first strategyRegister Now


Microsoft Access 2013 - Event to automatically update another field

Posted on 2014-08-30
Medium Priority
Last Modified: 2014-08-30
I have a field on a form which once updated will cause a Listbox to requery and display new results.

However, it is a date field, and once they have chosen the date in the date picker in needs to automatically update the listbox, without doing anything else. As far as I can tell, on events can cause this without the user clicking elsewhere on the form. So, immediately upon clicking on a day in the date picker, the listbox needs to requery.

Is there a way to do this?
Question by:rick_danger
  • 2
LVL 49

Accepted Solution

Dale Fye earned 2000 total points
ID: 40294598
you might try the textbox change event,  but in the change event, you have to refer to the .text property of the control, because the .value property of the control has not changed.

sent from my IPad

Author Comment

ID: 40294716
This still requires me to click the mouse on another field before it updates the listbox though.

Author Closing Comment

ID: 40294750
I actually got it working from the OnDirty event, however your tip about the .text property of the control was useful, so will award you the points

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question