Text Box get text added to table 1

[JaBurd311]

I have a Form with an unbound textbox with a Add button right next to it. I want to allow the user to type something into the textbox and then click the Add button to have what is in the textbox added to my table.

Thanks in advance.

Jason

 

[mdthornton]

In the click event for the add button put something like:

CurrentDatabase.execute "insert into myTable values('"+Me.textBox1+"')"

This is bare minimum, you should probably add logic to test for empty strings etc if appropriate. Best Regards,
Mike

 

[JaBurd311]

Thank you mdthornton,

Just what I needed.