JaineyBlue
Technical User
Still working on this damn vehicle database and need help with combo boxes please!
Have three forms - Vehicles, Trailers, Equipment. Each of the forms has embedded subforms, one being Location [subAutomLoc], which has the user group info for each vehicle. The user group info is 4 cascading combo boxes (branch, department, section1, section2). I've managed to get the combo boxes working in the Vehicles form by using the following in rowsource in the child comboboxes:
SELECT DISTINCT CostCentresTbl.Department FROM CostCentresTbl WHERE (((CostCentresTbl.Branch)=[Forms]![Form-Vehicles].[Form]![fsubAutomLoc]![Branch])) ORDER BY CostCentreTbl.Department;
And so forth with Sections 1 and 2.
My problem is, this works great in the Vehicles form but won't work in the Equipment or Trailers forms because it references the choice of Branch you make in the Vehicles form. Is there any way I can have the subform work in all 3 forms?
Have three forms - Vehicles, Trailers, Equipment. Each of the forms has embedded subforms, one being Location [subAutomLoc], which has the user group info for each vehicle. The user group info is 4 cascading combo boxes (branch, department, section1, section2). I've managed to get the combo boxes working in the Vehicles form by using the following in rowsource in the child comboboxes:
SELECT DISTINCT CostCentresTbl.Department FROM CostCentresTbl WHERE (((CostCentresTbl.Branch)=[Forms]![Form-Vehicles].[Form]![fsubAutomLoc]![Branch])) ORDER BY CostCentreTbl.Department;
And so forth with Sections 1 and 2.
My problem is, this works great in the Vehicles form but won't work in the Equipment or Trailers forms because it references the choice of Branch you make in the Vehicles form. Is there any way I can have the subform work in all 3 forms?