Runt time error 3164 field can not be updated

[sprtrmp]

I am (STILL) working on the attached inventory control db, and have it pretty close to what I need it to do, except for one thing that is giving me trouble.

I have a form called frmAssigned that is based on a query and a table by the same name. the form allows me to choose an employee, select a category and size of an item to ad to a list, blah, blah, blah...

along with the item being added, I can indicated a quantity of that item in a text box on the form called txtHRQuant (this is the number of the selected item being issued to the employee). I also have a textbox (txtOnHand) that shows the "quantity available" of an item that the underlying query pulls from a different table (tblproducts) that shows the number in inventory.

what I am ultimately trying to do is subtract the quantity issued (txtHRQuant) from the available quantity (txtOnHand), then put the resulting number back into the table in the correct recordset for the item selected. I hope I explained that well enough.

I have tried several versions of VBA and when I try to "write" the result back to the table (tblProducts), I get an error that says "run time error 3164, field can not be updated". which I find a little funny, because there is another form (frmAddItems) that I use to write data to the exact same quantity location on the products table and there are no errors. in other words, there are 2 different forms sending updated values to the same field on a table, one of the forms causes an error, the other doesn't, which would make me believe that it is NOT a question of the field being disabled, locked, or uneditable.



I am sure it is something that I am missing or just haven't learned yet.

Anyway, thanks for the time, and I seriously appreciate any help
MikeALWorking.zip

[RuralGuy]

I'm going to start with two suggested links:

http://allenbrowne.com/ser-61.html
http://allenbrowne.com/casu-14.html
.
If you've reviewed these links to no avail then post back and we can look deeper.

[sprtrmp]

I'm going to start with two suggested links:

http://allenbrowne.com/ser-61.html
http://allenbrowne.com/casu-14.html
.
If you've reviewed these links to no avail then post back and we can look deeper.

Thanks for taking a look, but I don't think either situation applies. I have a very simple query set up, and there is another form out there that is able to write data back to the table, so it seems to be working from that angel, at least.

I am also not using any calculated fields. All of the calculations are coded into the onclick even of a button on the form, and the new calculated total needs to be stored, so I can't use a calculated field. the error occurs after the math is completed and at the point where the data (new calculated total) is attempted to be written back to the table.

[orange]

I got this attached error when trying to use the form.

[sprtrmp]

hmm, I have never seen that one before, and, except for the related error, works OK.

[RuralGuy]

Wellll! I'm able to get your error and so far unable to figure out why. I think it should work.

[RuralGuy]

I'm going to take my best guess. The txtOnHand control is bound to the Quantity field of the tblProducts table. The cmbHRDescription cbo is bound to essentially a query of the tblProducts table. The AfterUpdate event of the cmbHRCategorySelect cbo REQUERIES the cmbHRDescription cbo (which is needed) but it probably invalidates the current frmAssigned Recordset and so the bound field of the txtOnHand control as well. The test for this would be to try and modify the txtOnHand control before the REQUERY.
It is just a guess. I have not tried it yet, but I will.

[RuralGuy]

Okay, that was an interesting exercise but useless. Same problem. I'll keep looking.

[RuralGuy]

I pretty convinced there is nothing in the form to synchronize the Recordset to your actions. Basically, I believe the Form's Record Source is really not valid for writing to. I don't know how I would change it yet. Still looking.

[RuralGuy]

From Help:

If there is no current record, as when there are no records in the
Recordset object, AbsolutePosition returns –1. If the current
record is deleted, the AbsolutePosition property value isn't defined, and
a trappable error occurs if it's referenced. New records are added to the end of
the sequence.

I've added a TextBox txtShow to the form and it *always* returns -1. This means there in NEVER a valid record in the Form's Recordset.

[RuralGuy]

I hope that is helpful to you. I know it was to me. As I suspected, it will not work as you expect until you can synchronize the recordset and I do not see any useful way to do that.

[sprtrmp]

hmmm, very curious. I don't understand why it is acting that way.
ah well, back to the drawing board. thanks for spending the time with it.

[RuralGuy]

You're very welcome.