Hello!
I am using a command button event to auto populate a set of tasks for each main record. Currently I am able to append all task descriptions into my tasks table - however I need to link them to the ShowID of my main form.
Following details:
tblTaskDescriptions
..ID
..TaskDesc
tblTasks
..ID
..Show ID
..Task
frmShows
..subfrmTasks
..command button
Current Code on button
I'm not sure what to add in for WHERE or if I can use this parameter at all.Code:DoCmd.RunSQL "INSERT INTO tblTasks (Task) " & _ "SELECT TaskDesc " & _ "FROM tblTaskDescriptions " & _ "WHERE [ShowID]=[Forms]![Shows]![ShowID];"
Thanks for your help!