SQL statement that saves form details to table

[Cordeiro82]

I have been trying to do this and I cant seem to figure it out. I need to write an SQL statement that allows the user to choose (at the click of a button) whether he wants to save the details entered into a form to a table or not. Any ideas?

 

[PCLewis]

I think you must be asking how to write an SQL statement to insert data into a table?

Because if you knew that, then you would be able to figure out how to write your Form code to do it.

When I am stuck like that, I use the Access query builder GUI to do what I want. Then you can switch the query builder to SQL mode and copy/paste the SQL.

An example of an INSERT query to get you started:

INSERT INTO SubTable7 ( NumberData, StringData, DateData )
SELECT 1, 'This is my string data', #30-Aug-2005#