Forms is not updating data

[RiderJon]

Hi,

I have a form that pulls data from a table. Easy.

But when I modify data from the form, it does not get updated on the table. I have tried clicking on the write button (the left bar) before logging out.

Funny part is that it was working just a few days ago.

pls. let me know what I might have overlooked or do I need to update using VBA tbl.update etc.

This is the only form that's not working in the whole database.

Thank you,





RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave

 

[jimb0ne]

I have run into a similar problem a few times. I've found that if my data isn't getting saved sometimes the following works:

with me.recordset
.edit
.update
end with

for some reason updating the recordset seems to save the information that wasn't getting saved previously. I'm not sure how your DB is set up, but if you are referencing the table directly and not using a query I'd suggest trying the above if you have exhausted all other avenues.

 

[mph1]

The problem you have seems to be two fold. Updating, but, to me, more importantly, is the fact that whatever you were doing had been working and now it doesn't.

Assuming that what you are doing now is the same as before when the updating did work, I would suggest creating a new form. It sounds like the current form has become corrupted for whatever reason (it can happen).

HTH

An investment in knowledge always pays the best dividends.
by Benjamin Franklin

 

[RiderJon]

Thank you all for the reply. I just re-imported the form from my backp and it seems to work for now.

RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave