Hi,
I know this is a dump question..
I am trying to insert a row to a table from the data I got from mt form. How do I do this ?
My insert query(qryInsert) looks like this:

INSERT INTO ToDoItems ( TD_Call_Taken_By )
SELECT [forms]![ToDoEntryScreen]![dtxTakenBy].[text] AS Expr1;

not sure this is correct or not..

How di I call this from my Private Sub cmdAdd_Click() ?

Help ..

In your sub, insert the following line:

Docmd.OpenQuery "qryInsert"

If the form is bound to the table into which you want to insert a row, simply moving to a different record will effect the save without any coding.