Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Requery after TextBox update

Posted on 2013-12-11
2
Medium Priority
?
3,342 Views
Last Modified: 2013-12-11
I have created a form in Access 2010.  I have a Text Box that uses a Date Picker, with a Short Date format, to select a date to be used as criteria within a query attached to a ListBox to select records from a table for a Date/Time (Short Date Format) field equal to the TextBox value.

My question is how to get the form to refresh the ListBox query after the Text Box has been updated.

Do I use the OnUpdate property of the text Box with a VBA code and then focus on the List Box?

Please recommend the best process and syntax for this.

thanks

glen
0
Comment
Question by:GPSPOW
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 39713122
use the afterupdate event of the date textbox

private sub textboxName_afterupdate()

me.listboxName.requery

end sub
0
 

Author Closing Comment

by:GPSPOW
ID: 39713127
Works perfectly

Thank you

Glen
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
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.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

578 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