Great Day, I have a form that keeps track of repair orders at an automobile repair shop. The parent form has a number of fields - date of repair, mileage of vehicle, technician who worked on it, etc. I also have 4 subforms:
1. frmJobCustomer Sub - Identifies customer for work being done
2. frmJobVehicle Sub - identifies vehicle for service
3. frmPartsUsedSub - identifies the parts used during repair and their costs
4. frmScopOfJobSub - Identifies labor done on vehicles and the cost of the labor.
In frmJobVehicle /Sub, I created a combo box to permit the user to select which vehicle is being serviced. HOwever, the combo box does not permit me to select a vehicle. I can see all of the vehicles, but in the bottom of the screen, I see the following message:
Control can't be edited; It's bound to autonumber field 'VehicleID'.
The subform does allow for edits and the field is enabled and not locked. VehicleID is ot visible, but the other three fields are, and the bound column is '1'.
The SQL for the combo box is provided below.
Thanks in advance,
SELECT tblVehicles.VehicleID, tblMakes.Make, tblModels.Model, tblVehicles.[Tag-State]
FROM tblModels INNER JOIN (tblMakes INNER JOIN tblVehicles ON tblMakes.MakeID = tblVehicles.MakeID) ON tblModels.ModelID = tblVehicles.ModelID
ORDER BY tblMakes.Make;