G
Guest
I have built a main form containg 4 unbound combo boxes (ProjectID,
DisciplineName, SectionNumber and Last Name) giving the user a choice in
which to display information in a subform based on one or a combination of
selections from the combo boxes.
Form information:
record source (tblProject Staffing Resources)
Parent/Child Link - (ProjectID)
Subform information:
record source - qryProjectID
SQL view of query:
SELECT [tblProject Staffing Resources].ProjectID, [tblProject Staffing
Resources].DisciplineName, [tblProject Staffing Resources].SectionNumber,
[tblProject Staffing Resources].[Staff Last Name], [tblProject Staffing
Resources].[Staff First Name], [tblProject Staffing Resources].[Discipline
Lead], [tblProject Staffing Resources].[Est Project Start Date], [tblProject
Staffing Resources].[Est Project End Date], [tblProject Staffing
Resources].EmployeeID
FROM [tblProject Staffing Resources]
WHERE ((([tblProject Staffing Resources].ProjectID)=[Forms]![frmProject
Staffing Resources(1)]![ProjectID])) AND ((([tblProject Staffing
Resources].DisciplineName)=[Forms]![frmProject Staffing
Resources(1)]![DisciplineName])) AND ((([tblProject Staffing
Resources].SectionNumber)=[Forms]![frmProject Staffing
Resources(1)]![SectionNumber])) OR ((([tblProject Staffing
Resources].DisciplineName)=[Forms]![frmProject Staffing
Resources(1)]![DisciplineName]) AND (([tblProject Staffing
Resources].SectionNumber)=[Forms]![frmProject Staffing
Resources(1)]![SectionNumber]) AND (([Forms]![frmProject Staffing
Resources(1)]![ProjectID]) Is Null)) OR ((([tblProject Staffing
Resources].ProjectID)=[Forms]![frmProject Staffing Resources(1)]![ProjectID])
AND (([tblProject Staffing Resources].SectionNumber)=[Forms]![frmProject
Staffing Resources(1)]![SectionNumber]) AND (([Forms]![frmProject Staffing
Resources(1)]![DisciplineName]) Is Null)) OR ((([tblProject Staffing
Resources].SectionNumber)=[Forms]![frmProject Staffing
Resources(1)]![SectionNumber]) AND (([Forms]![frmProject Staffing
Resources(1)]![ProjectID]) Is Null) AND (([Forms]![frmProject Staffing
Resources(1)]![DisciplineName]) Is Null)) OR ((([tblProject Staffing
Resources].ProjectID)=[Forms]![frmProject Staffing Resources(1)]![ProjectID])
AND (([tblProject Staffing Resources].DisciplineName)=[Forms]![frmProject
Staffing Resources(1)]![DisciplineName]) AND (([Forms]![frmProject Staffing
Resources(1)]![SectionNumber]) Is Null)) OR ((([tblProject Staffing
Resources].DisciplineName)=[Forms]![frmProject Staffing
Resources(1)]![DisciplineName]) AND (([Forms]![frmProject Staffing
Resources(1)]![ProjectID]) Is Null) AND (([Forms]![frmProject Staffing
Resources(1)]![SectionNumber]) Is Null)) OR ((([tblProject Staffing
Resources].ProjectID)=[Forms]![frmProject Staffing Resources(1)]![ProjectID])
AND (([Forms]![frmProject Staffing Resources(1)]![DisciplineName]) Is Null)
AND (([Forms]![frmProject Staffing Resources(1)]![SectionNumber]) Is Null))
OR ((([Forms]![frmProject Staffing Resources(1)]![ProjectID]) Is Null) AND
(([Forms]![frmProject Staffing Resources(1)]![DisciplineName]) Is Null) AND
(([Forms]![frmProject Staffing Resources(1)]![SectionNumber]) Is Null));
Select Button (command button):
DoCmd.Requery qryProjectID
Now the problem is when a selection is made from the ProjectID combo box the
subform shows the correct results.
But when a selection is made from the other combo boxes (DisciplineName,
SectionNumber and LastName) nothing appears in the subform. And if a
combination of selections are made from more than one combo box nothing
appears once the Select button is clicked.
Will someone please help me figure out what is wrong?
Thanks
DisciplineName, SectionNumber and Last Name) giving the user a choice in
which to display information in a subform based on one or a combination of
selections from the combo boxes.
Form information:
record source (tblProject Staffing Resources)
Parent/Child Link - (ProjectID)
Subform information:
record source - qryProjectID
SQL view of query:
SELECT [tblProject Staffing Resources].ProjectID, [tblProject Staffing
Resources].DisciplineName, [tblProject Staffing Resources].SectionNumber,
[tblProject Staffing Resources].[Staff Last Name], [tblProject Staffing
Resources].[Staff First Name], [tblProject Staffing Resources].[Discipline
Lead], [tblProject Staffing Resources].[Est Project Start Date], [tblProject
Staffing Resources].[Est Project End Date], [tblProject Staffing
Resources].EmployeeID
FROM [tblProject Staffing Resources]
WHERE ((([tblProject Staffing Resources].ProjectID)=[Forms]![frmProject
Staffing Resources(1)]![ProjectID])) AND ((([tblProject Staffing
Resources].DisciplineName)=[Forms]![frmProject Staffing
Resources(1)]![DisciplineName])) AND ((([tblProject Staffing
Resources].SectionNumber)=[Forms]![frmProject Staffing
Resources(1)]![SectionNumber])) OR ((([tblProject Staffing
Resources].DisciplineName)=[Forms]![frmProject Staffing
Resources(1)]![DisciplineName]) AND (([tblProject Staffing
Resources].SectionNumber)=[Forms]![frmProject Staffing
Resources(1)]![SectionNumber]) AND (([Forms]![frmProject Staffing
Resources(1)]![ProjectID]) Is Null)) OR ((([tblProject Staffing
Resources].ProjectID)=[Forms]![frmProject Staffing Resources(1)]![ProjectID])
AND (([tblProject Staffing Resources].SectionNumber)=[Forms]![frmProject
Staffing Resources(1)]![SectionNumber]) AND (([Forms]![frmProject Staffing
Resources(1)]![DisciplineName]) Is Null)) OR ((([tblProject Staffing
Resources].SectionNumber)=[Forms]![frmProject Staffing
Resources(1)]![SectionNumber]) AND (([Forms]![frmProject Staffing
Resources(1)]![ProjectID]) Is Null) AND (([Forms]![frmProject Staffing
Resources(1)]![DisciplineName]) Is Null)) OR ((([tblProject Staffing
Resources].ProjectID)=[Forms]![frmProject Staffing Resources(1)]![ProjectID])
AND (([tblProject Staffing Resources].DisciplineName)=[Forms]![frmProject
Staffing Resources(1)]![DisciplineName]) AND (([Forms]![frmProject Staffing
Resources(1)]![SectionNumber]) Is Null)) OR ((([tblProject Staffing
Resources].DisciplineName)=[Forms]![frmProject Staffing
Resources(1)]![DisciplineName]) AND (([Forms]![frmProject Staffing
Resources(1)]![ProjectID]) Is Null) AND (([Forms]![frmProject Staffing
Resources(1)]![SectionNumber]) Is Null)) OR ((([tblProject Staffing
Resources].ProjectID)=[Forms]![frmProject Staffing Resources(1)]![ProjectID])
AND (([Forms]![frmProject Staffing Resources(1)]![DisciplineName]) Is Null)
AND (([Forms]![frmProject Staffing Resources(1)]![SectionNumber]) Is Null))
OR ((([Forms]![frmProject Staffing Resources(1)]![ProjectID]) Is Null) AND
(([Forms]![frmProject Staffing Resources(1)]![DisciplineName]) Is Null) AND
(([Forms]![frmProject Staffing Resources(1)]![SectionNumber]) Is Null));
Select Button (command button):
DoCmd.Requery qryProjectID
Now the problem is when a selection is made from the ProjectID combo box the
subform shows the correct results.
But when a selection is made from the other combo boxes (DisciplineName,
SectionNumber and LastName) nothing appears in the subform. And if a
combination of selections are made from more than one combo box nothing
appears once the Select button is clicked.
Will someone please help me figure out what is wrong?
Thanks