I Need VBA Assistance to set a record value in a table

[Guest]

Good morning,

I am making an Access VBA module and need assistance. I made a table to
contain a single record and I need to know if there is a way first to assisgn
this record to get its value from a text box on a form entered by a user? And
then to use VBA to make this record automatically update its value anytime a
user types another value in this text box and clicks on UPDATE button. My
table name is CURRENT_YEAR and my form name is CURR_YEAR.Any suggestions?
Thanks.

 

[Ken Snell [MVP]]

Why not set the form's Record Source to the table, and bind the textbox to
that field? That way, the form will do that for you.