David-
I believe when you requery lst1, that resets its value, so yes, you should requery 2 and 3 when that happens. Setting (or resetting) a value from an action in code does not fire the After Update event.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Feb 28, 2017, at 5:35 PM, david.pratt@outlook.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
When I have a form with multiple combos or list boxes, I am not certain when I have to requery them.
For example, I have lst1, lst2 and lst3 on a form, and in the after update event of lst1, I requery lst2 and lst3. In the after update event for lst2, I requery lst3.
I have a cmd button where I add a record to lst1, and within the cmd button statements after the add form is closed, I requery lst1. Does the after update event on lst1 cause requerying of lst2 and lst3. Or do I specifically have to requery those lists?
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar