Text field refuses to change programmatically

[kdbailey]

For the life of me I cannot figure this one out. Based on a variable, a text field within a table is edited to one string or another.

with rs
  .Edit    
    If r = 0 Then
        ![Status] = "Recalled"
    Else
        ![Status] = "Complete"
    End If
  .Update
end with

It will edit to "Complete", but it refuses to go the other way. When r = 0 it will not revert from "Complete" to "Recalled".

[Xipooo]

rs looks like a recordset, not a text field.

[kdbailey]

It is, but the field ![Status] is a text field.

I found where the error was occurring, it was later on following this section of code.

[Xipooo]

Yes, but that doesn't matter. You are using the "with" keyword. The ! in front of [Status] indicates that status is a field inside of the recordset.

Change ![Status] to me.status.

Also, .edit and .update means you are editing and updating the recordset with the data. It has nothing to do with the text box.

[kdbailey]

Text FIELD, as in a text field on a table.

[Xipooo]

Text FIELD, as in a text field on a table.

Ahh, I gotcha. Sorry for the confusion.

[kdbailey]

Not a problem, I included "text field" for others to ensure that I wasn't trying to put text into a Number Field or something. I found the error, it had to do with situation recognition further down in the code. It was changing it, and then changing back based on other criteria.

Problem is solved.