As in the title, my problem is the disappearing values in the text box after closing the form. I wrote a macro
Code:
Public Sub Form_Close()
CurrentDb.Execute "INSERT INTO tbl_values" _
& "(column_value_1,column_value_2,column_value_3,column_value_4,column_value_5) VALUES" _
& "('" & text_field_1 & "','" & text_field_2 & "','" & text_field_3 & "','" & text_field_4 & "','" & text_field_5 & "');"
End Sub
When I close form it gets these values and inserts into the table but I can't take back this values when I open the form.
Could someone help me?
Maybe it can be done in a different way
Regards and thanks for help