Ms Access Error 3331

[RH610]

In Access2000 I get the following error

Error 3331
Before you can update this field, first save the record

when the line below is executed

Forms![New Advisor]![Firm#] = Me.[Firm#]

This line is in the "after update" section of a form (not the 'New Advisor' form) that essentially gets the [Firm#].
I am not sure what 'record' they are talking about saving, since the the record should already be saved if I am in the 'after update' section and I don't know why I should save the record from the 'New Advisor' form if I am just changing the value of a field on it.

Thank You

 

[SKIGAL]

I think I understand the question.

And I've run into something similar. The me![field] is not stored (or saved) in the table until the record is "saved". "Saved" by adding a new record, going to a different record, etc.

In my case, I wrote a couple of lines of code to close and reopen the form right quick. This allowed the record to be "saved" and further processing to occur.

Hope this helps.