Update query to add new row

[JohnMcCririck]

I have heard that an update query can be used to add a new row to a table... for example once a user fills out a form the update query would run and save the fields to a new row in the designated table.

Is this all crazy talk?

 

[Golom]

I think it is. INSERT queries add new rows. UPDATE queries change existing rows.

 

[JohnMcCririck]

Thanks for the quick reply!

I've never heard of an INSERT query, would it be suitable for adding a new row to a table from data inputted into text boxes on a form?

 

[Golom]

Sure

SQL = _
"INSERT INTO tablename (f1, f2) " & _

"VALUES ('" & txtbox1.Text & "', '" & txtbox2.Text & "' )"

Inserts a new record into table "tablename" and assigns the values from two text boxes to fields "f1" and "f2". The syntax changes slightly for different data types.

 

[JohnMcCririck]

Nice one, I've got the basics working.

Thanking you!

 

[JohnMcCririck]

Running into problems now...

My table has 3 fields from user inputted data (text boxes on a form), an autonumber field, a field showing date of entry, and 2 more fields which are calculated.

How would I go about inserting them all? Should I try inserting the results of another query that runs previous to the INSERT query?

(I know you're not supposed to store calculated fields but I want to in this case)