Continuous form with Listbox

B

Build or Die

I have an unbound form with a continuous subform on it. The subform displays
all current projects and basic information for searching and a few buttons to
other forms. I would like to include the client (companyID) on this subform
but multiple records for the same project number apear when there are
multiple client listings for one project.

I'm thinking a list box could solve the problem of listing one or more
clients per project, but I'm lost on getting the listbox to link by project #
(like a parent-child link for subforms). Would a GROUP BY work? or perhaps
an unbound Listbox that populates ON Current & On requery?

Any help?
Thanks

Current Query:
SELECT DISTINCT tblProject.ProjectYear, tblProject.ProjectID,
tblProject.ProjectName, tblProject.ProjectCity, tblProject.ProjectState,
[ProjectCity] & "," & " " & [ProjectState] AS CityState FROM tblProject INNER
JOIN (tblCompanyOrVillage INNER JOIN tblcontactdetails ON
tblCompanyOrVillage.CompanyOrVillageID=tblcontactdetails.CompanyID) ON
tblProject.ProjectID=tblcontactdetails.ProjectID ORDER BY
tblProject.ProjectYear DESC , tblProject.ProjectID DESC;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top