Access form not saving data to backend DB in some cases

[CodeLiftSleep]

I am at my wit's end on this one,



I have a form where people can make changes to their inputs and it calculates a "scorecard" for them and then saves it to the backend DB. When they go back to the initial form it refreshes the page and shows the updated info. This was working fine for quite some time but all of a sudden, it no longer is updating properly.

The information is there and correct(I'm checking the field value properties immediately prior to updating via putting a breakpoint on the Update call), but when it calls RS.Update, the information is not being updated at all in the DB. I check the backend DB and the information is still the same as it was prior to the update.

Specifically, it's only the scores that aren't updating. The data is updating fine. So for instance, I have ClientVisits and change it from 3 to 4, that updates fine. But when it goes to update JunScore(which takes in all the data for the month and spits out a score), that doesn't save at all. So it seems like it is selectively updating...

I thought it might have something to do with the datatype, but no, all the score columns are number and the values being passed in are 2 digits numbers.

Anyone have an idea of what could be happening? No errors are being generated, it just isn't updating.

[ranman256]

strange. once you update ,it stays. check:
all table links are pointing correctly,
then run an update links anyway.
if you are entering data via parent/sub tables, make SURE the sub table is Linked on the form via the parent key. IF not you may get orphans.

[Micron]

I'm checking the field value properties immediately prior to updating via putting a breakpoint on the Update call), but when it calls RS.Update, the information is not being updated at all in the DB. I check the backend DB and the information is still the same as it was prior to the update.

This probably isn't it, but if you are looking at table data, then running an operation on that table, viewing the table again does not refresh the view. To ensure this isn't the problem, click Refresh All on ribbon when the table is the active window. If that's not it, something must have changed which has caused the query to fail. Are these two updates separate queries?

[CodeLiftSleep]

This probably isn't it, but if you are looking at table data, then running an operation on that table, viewing the table again does not refresh the view. To ensure this isn't the problem, click Refresh All on ribbon when the table is the active window. If that's not it, something must have changed which has caused the query to fail. Are these two updates separate queries?

It was actually a piece of code that I meant to remove and forgot to causing the issue....before I realized you can control allowing NULL's in Access by using Required, I wrote code to check the fields and made them "" if they were NULL before saving...

This was throwing a silent error because some of the fields that were NULL apparently were number fields, so some of them weren't updating properly...I removed the code and it now works as expected.