Hello....I am also new to Access...and writing codes. I am currently creating a database where I have subforms. I want to have information flow from the main form to the subform for some fields. Then I want all of this information to flow to a table. So, I have created another table. This is the code I am using. It is not working, please help.

Private Sub Form_Load()

Dim db As DAO.Database
Set db = CurrentDb

CurrentDb.Execute = "INSERT INTO tblUpdateDate ( [Project ID], [Project Name], [Update Date] ) " & _
"SELECT s.[Project ID], s.[Project Name], s.[Update Date] " & _
"FROM tblAssessmentForm AS s WHERE (((s.[Project ID])=[Forms]![frmAssessmentForm]![Project ID]))"

DoCmd.RunSQL (sql)

You can do this, but you have to take the values as variables, then use the variables in your SQL statement. Put the entire SQL statement in its own variable, and then execute it.

Does this help?

mmcdonal

Dim sql as string

sql = "INSERT INTO tblUpdateDate ( [Project ID], [Project Name], [Update Date] ) " & _
"SELECT s.[Project ID], s.[Project Name], s.[Update Date] " & _
"FROM tblAssessmentForm AS s WHERE (((s.[Project ID])=" & [Forms]![frmAssessmentForm]![Project ID] & "))"

DoCmd.RunSQL (sql)

BTW: Since most if not all submissions to a forum would be questions, it is not very helpful to make your subject "Question". I would suggest that the current topic should be something like "Querying Using a Subform". With all the messages that get posted to forums, I'm usually inclined to skip over those with an uninformative subject line.

-Phil-