I have a Single form with its RecordSource set to one table.
This form will have only one record that is used for the application
setup.
I have UnBound TextBoxes on the form. The textboxes will get filled,
and I want to have this data saved to the single record of the Table
using the OnClosed event.
The problem is that I get the error "You can't assign a value to this
object". The code below works fine when placed under a button. I
have the impression that the OnClose event may be too late for the
value assignment? How do I make the assignment??? Can this be done
without making DAO references?
Private Sub Form_Close()
Me.FIELD1 = EncryptDecrypt(Me.txtBox1)
Me.FIELD2 = EncryptDecrypt(Me.txtBox2)
End Sub