automatic save has stopped working

[Karaline]

usually when i enter on form and tab to last cell it will take me to new page and automatically save data.


this has stopped working

i had a working macro but it is now telling me error update and won't go to new page I am useless at VBA unless it is written out for me. I can't create to save my life.

Update or CancelUpdate without AddNew or Edit

not sure what I can do to fix this?

[ranman256]

There is no vb required to save. It is automatic when you leave a record.

[Karaline]

yes, but it wont go to new page has stopped working and i have attached what is now saying to me.
i added the calculation for my previous question to beforeupdate could that be the problem?

[Missinglinq]

...i added the calculation for my previous question to beforeupdate could that be the problem...

What, exactly, do you mean by this? The BeforeUpdate events are Access saving either a Control's data (if ControlName_BeforeUpdate) or saving the entire Record (if Form_BeforeUpdate) and, yes, there are a number of things you could be attempting here that aren't allowed, because it prevents Access from doing just that...saving the data...we really need to either see your file or at least the pertinent code to help.

Linq ;0)>

[NTC]

Sorry I never open attachments: Generically speaking - when one tabs through a bound form the tab process will continue to the next record (the term 'page' is not a defined element - so that is unclear - one can have tabbed form features as well....)

No code is needed on this. In fact, code is needed to stop this from happening - in terms of tabbing to the next record.

There may be code in the Update event - but if you don't write code then it could be just the normal process of writing the record to the table as it advances to the next record. Code doesn't just stop working. Possibly it is data dependent and it can't find the right data - in which case it will work sometimes but not others - and you can determine which critical field is the issue.