David-
The form is:
Me.NameOfSUBFORMControl.Form!NameOfCombo.Requery
Note that it's not the name of the subform inside the control - that might be different from the name of the control.
John Viescas, author
John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications
On Dec 17, 2016, at 05:21, david.pratt@outlook.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have a main form and subform. In the main form I have an unbound combo in the header to filter the records of the main form. In the subform I have a combo box which I am trying to filter based on a field in the main form. The subform combo box works fine the first time the main form is opened and filtered with the unbound combo. However, when I change the value in the unbound main form combo, the combo in the subform doesn't work.
I think the subform combo needs to be requeried when the main form unbound combo is changed. I don't know how to do that, or if in fact that is my problem. When I try to type in the subform name in the AfterUpdate event, it is not in the list of objects from which I can select.
Help please.
__._,_.___
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