OK, here are the details that seem relevent to me. I have poured over the
various controls and code and can't find anything that seems wrong, so I can
only assume that there is either a glaring error that is to obvious for me
to see, or a minor detail that I am not knowlegable enough to spot...
My main form [frmMainMenu] has a header with a series of command buttons,
the relevent one being [WorksheetButton]. The form detail contains two
unbound subforms, one named [FormFrame] the other [SecondaryFormFrame]. When
the user clicks [WorksheetButton], the SourceObject of [FormFrame] is set to
[frmWorksheet]:
Me!FormFrame.SourceObject = "frmWorksheet"
On the subform - [frmWorksheet] there is a header with two combo box
controls. The first is [SelectClient] which is populated from a query
"qryClientList":
SELECT tblClients.Client, tblClients.ClientID, tblClients.HomePhone,
tblClients.OfficePhone, tblClients.CellPhone,
tblClients.Location FROM tblClients ORDER BY tblClients.Client;
This combo contains a list of all the clients from "tblClients". Once a user
selects a client, the OnUpdate event triggers:
Me!SelectProject.Enabled = True
Me!SelectProject.Requery
EnableControls Me, acDetail, False
This enables the second combo box control [SelectProject] and is supposed to
populate it with a list of projects associated with the client chosen in the
first combo. The datasource is a query "qryProjectsByClient":
SELECT tblProjects.Project, tblProjects.ProjectID, tblProjects.ClientID,
tblProjects.Status
FROM tblProjects WHERE
(((tblProjects.ClientID)=[Forms]![frmMainMenu]![SelectClient]) AND
((tblProjects.Status) ="Pending" Or (tblProjects.Status)="In
Progress"));
Problem is, I see the list of clients in the SelectClient control, I select
a name and the screen flickers (as it does when it requeries) but nothing
appears in the SelectProject control. I don't thing it ever gets to this
point but, the AfterUpdate event for the SelectProject controls is:
DoCmd.ApplyFilter , "ProjectID = Forms!frmMainMenu!SelectProject"
EnableControls Me, acDetail, True
Me!ProjectID.Enabled = False
When I had this form open as a stand alone form (before I changed the form
references in "qryProjectsByClient" and the AfterUpdate event, these events
worked perfectly. I have checked all of the code in frmWorksheet and all of
the datasources and there is no other references to "frmWorksheet" that I
can find.
Do you see something in the code above that could present a problem? or is
there someplace else that I should look? I am afraid that I have tapped out
my pool of knowledge, so any help would be greatly appreciated.
"Bob Quintal" <rq******@sympatico.ca> wrote in message
news:Xn*********************@207.35.177.135...
"Robert" <no**@email.com> wrote in
news:Ii*****************@fe09.news.easynews.com:
those references using me. should still work. Without careful
examination of the code and the queries, it's difficult to say
what the problem is, but I have built several working unbound
forms with cascading comboboxes that filter a subform