SQL Insert Into statement using data gathered from a form in MS Access.
It's pretty common to gather information from a user in a form in MS Access. How do you add that data to a table. The SQL statement you need is an insert statement. In this video I briefly introduce you to an insert statement and show you how to build a form that gathers input from a user and then inserts the data into a table.
You can find the code from this video on my blog here...
https://www.huexcel.com/post/sql-inse...
In a previous YouTube video I explain additional SQL statements you can use. All of these can be executed using CurrentDb.Execute.
• Introduction to SQL
https://www.huexcel.com/