Field Cannot Be Update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a form with a sub form in it. the sub form is linked to a qry. When i
click on the combo box for the sub form and select a value it comes up with
an error msgbox saying field cannot be updated. when i select ok the combo
box is updated with the selected value. The combo box can be changed as many
times as you want now without the error msg.

wheres this error msg coming from?
 
Tell us what the SQL statement is for the subform's RecordSource. Tell us if
the combobox is bound to a field in that RecordSource query or not. Tell us
more details, please, about the subform and what code may be running in the
Current event for the subform's Source Object form.
 
this is my record source for the sub form

SELECT qryWorkOrdersMaterialsTotals.[Work Order ID],
qryWorkOrdersMaterialsTotals.Supplier,
qryWorkOrdersMaterialsTotals.Description,
qryWorkOrdersMaterialsTotals.[Receipt Invoice Number],
qryWorkOrdersMaterialsTotals.Cost, qryWorkOrdersMaterialsTotals.[Add
Percentage], qryWorkOrdersMaterialsTotals.Total FROM
qryWorkOrdersMaterialsTotals;

the combo box control source is "Supplier" from the above. the ow source for
the combo is

SELECT tblSuppliersAddressBook.SupplierID,
tblSuppliersAddressBook.sCompanyName FROM tblSuppliersAddressBook ORDER BY
[sCompanyName];

the combo is enabled, not locked, limit to list yes, row source type is
table/qry.

There is no VBA in any of the event in the sub form or combo box. the sub
form has allow filters,edits,del,additions, no data entry, no locks and yes
to fetch defaults
 
Ive just changed the fetch defaults to NO on the sub form and it has got rid
of the error msg.

Thanks for replying to my message.
 
Back
Top