I have a form that is based on a query (tblProjects & tblProjectsContacts). I have a listbox on the same form with a button to add equipment to the project. The listbox's query is based on tblProjects & tblProjectsEquipment. This opens another form (frmProjectEquipmentSearch) to select Manufacturer and Model in a seperate listbox (based on a different table). When you double click the list, it opens another form (frmEquipment) where you can add detailed information for that project equipment (ie. install date, warranty date, etc.). When you click the add equipment it populates the list on the original form (frmProjects). I can get the list of ALL equipment, but when I change to the next Project the list does not change.
I have searched for a fix and I have seen the solution to add the criteria to the ID = forms!frmName!ControlName and add a requery to the forms current event but this doesn't work. When I add criteria I get a msgbox asking for the forms!frmName!ID.
Note: The Projects.ProjectID was not populated when adding new equipment. I had to pass the Projects.ProjectsID from frmProjects to frmProjectEquipmentSearch to frmEquipment just to set ProjectEquipment.ProjectID=Projects.ProjectID.
Does anyone know a solution in access or vb code I can enter??
Thanks for your help in advance,
Linda