David
I'm not sure if this will fix it but try this:
Is the RepairTypeID in tblRepairOrder? If so, try using it instead of tblRepairType_RepairTypeID in your SELECT clause.
That goes for all fields in tblRepairOrder. Use the foreign key instead of the primary key of the related table.
Using the primary keys in the other tables is probably causing the locking.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "djsdaddy531" <drtolson@...> wrote:
>
> I have two combo boxes in a form for Repair Orders in an automotive repair shop: One is for the Repair Type (RepairTypeID) and the other is for the Repair Technician (EmployeeID). If I the Repair Order combo box first when the form is opened, I get the following Access error:
>
> "Field Cannot be updated"
>
> and when I click onto the Help button, I get the following:
>
> "The field cannot be updated because another user or process has locked the corresponding record or table. (Error 3164)
>
> Possible causes:
>
> You tried to update a field in a record or table that is currently locked by another user. Wait for the other user to finish working with the record or table, and then try the operation again.
> In Microsoft Access, you tried to change the value of a control whose Locked property is set to Yes."
>
> But both locked properties are set to No.
>
> If I click Ok a few times in the Access error dialogue box, the value enters into the field, and the Repair Technician combo box is okay, but if I reverse the process by clicking the Repair Technician combo box I get the same access error - "Field cannot be updated", and then I can click on the Repair Type Combo Box withe no problem.
>
> Here is the form's Record Source:
>
> SELECT tblRepairOrder.RepairOrderID, tblRepairOrder.CustomerID AS tblRepairOrder_CustomerID, tblRepairOrder.CustomerVehicleID AS tblRepairOrder_CusVehicleID, tblRepairOrder.RepairTypeID AS tblRepairOrder_RepairTypeID, tblRepairOrder.RepairOrderPartsID, tblRepairOrder.PartCost, tblRepairOrder.QtyParts, tblRepairOrder.LaborCost, tblRepairOrder.DescribeRepair, tblRepairOrder.DateIn, tblRepairOrder.DateOut, tblRepairOrder.DateOfWarrantyWork, tblRepairOrder.MilageIn, tblRepairOrder.MileageOut, tblRepairOrder.EmployeeID AS tblRepairOrder_EmployeeID, tblMasterCustomer.CustomerID AS tblMasterCustomer_CustomerID, tblMasterCustomer.FirstName, tblMasterCustomer.LastName, tblMasterCustomer.[Street Address-Line 1], tblMasterCustomer.[Street Address-Line 2], tblMasterCustomer.City, tblMasterCustomer.State, tblMasterCustomer.ZipCode, tblMasterCustomer.HomePhone, tblMasterCustomer.BusinessPhone, tblMasterCustomer.MobilePhone, tblMasterCustomer.EmailAdress, tblCustomerVehicles.CustomerVehicleID AS tblCustomerVehicles_CusVehicleID, tblCustomerVehicles.Make, tblCustomerVehicles.Model, tblCustomerVehicles.ModYear, tblCustomerVehicles.Color, tblCustomerVehicles.VIN, tblCustomerVehicles.[Tag-State], tblRepairType.RepairTypeID AS tblRepairType_RepairTypeID, tblMasterEmployee.EmployeeID AS tblMasterEmployee_EmployeeID, tblRepairType.RepairType
> FROM tblRepairType INNER JOIN (tblMasterEmployee INNER JOIN (tblMasterCustomer INNER JOIN (tblCustomerVehicles INNER JOIN tblRepairOrder ON tblCustomerVehicles.CustomerVehicleID = tblRepairOrder.CustomerVehicleID) ON tblMasterCustomer.CustomerID = tblCustomerVehicles.CustomerID) ON tblMasterEmployee.EmployeeID = tblRepairOrder.EmployeeID) ON tblRepairType.RepairTypeID = tblRepairOrder.RepairTypeID;
>
>
> The Repair Type cpmbo box control source is tblRepairOrder_RepairTypeID
>
> and the Row Source is
>
> SELECT tblRepairType.RepairTypeID, tblRepairType.RepairType, tblRepairType.RepairCost FROM tblRepairType ORDER BY tblRepairType.RepairType;
>
>
> the Repair Technician Combo Box control source is tblRepairOrder_EmployeeID
>
> and the row source is
>
> SELECT tblMasterEmployee.EmployeeID, [LastName] & ", " & [Firstname] AS Name FROM tblMasterEmployee ORDER BY [LastName] & ", " & [Firstname];
>
>
> Any assistance will be greatly appreciated. Thanks in advance.
>
> r/David
>
Tidak ada komentar:
Posting Komentar