Access 2007 VBA - Insert query snytax error

[Moe1950]

Why do I get an "Invalid Bracketing of Name" with this? ( [forms]![pcmh data]![txtNewScenerio.Value] is specified but if I take that out, it just moves down to the next line)

INSERT INTO tbl_variables 
   (
     Scenerio, pu_type, PCMH_Capabilities, EBCR_Adult, 
     EBCR_Peds, Preventive_Adult, Preventive_Peds, 
     PCS_ED_Use_Adult, PCS_ED_Use_Peds, GDR_Rate_Adult, 
     GDR_Trend_Adult, GDR_Rate_Peds, GDR_Trend_Peds, 
     Low_Tech_Adult, Low_Tech_Peds, High_Tech_Adult, 
     PCMH_Points_Imp_CapAdult, PCMH_Points_Imp_Cap_Peds, 
     Small_n_Members, Require_3_Metrics, Number_of_PUs, 
     Required_Total_Score, Required_PU_Percentile, 
     Required_Num_Members, PU_Eligiblity_Threshold
  )
VALUES
  (
      [forms]![pcmh data]![txtNewScenerio.Value], 'Family', 
      [forms]![qryFamily subform]![PCMH_Capabilities], 
      [forms]![qryFamily subform]![EBCR_Adult],
      [forms]![qryFamily subform]![EBCR_Peds], 
      [forms]![qryFamily subform]![Preventive_Adult], 
      [forms]![qryFamily subform]![Preventive_Peds], 
      [forms]![qryFamily subform]![PCS_ED_Use_Adult], 
      [forms]![qryFamily subform]![PCS_ED_Use_Peds], 
      [forms]![qryFamily subform]![GDR_Rate_Adult], 
      [forms]![qryFamily subform]![GDR_Trend_Adult], 
      [forms]![qryFamily subform]![GDR_Rate_Peds], 
      [forms]![qryFamily subform]![GDR_Trend_Peds], 
      [forms]![qryFamily subform]![Low_Tech_Adult], 
      [forms]![qryFamily subform]![Low_Tech_Peds], 
      [forms]![qryFamily subform]![High_Tech_Adult], 
      [forms]![qryFamily subform]![PCMH_Points_Imp_CapAdult], 
      [forms]![qryFamily subform]![PCMH_Points_Imp_Cap_Peds], 
      [forms]![qryFamily subform]![Small_n_Members], 
      [forms]![qryFamily subform]![Require_3_Metrics], 
      [forms]![qryFamily subform]![Number_of_PUs], 
      [forms]![qryFamily subform]![Required_Total_Score], 
      [forms]![qryFamily subform]![Required_PU_Percentile], 
      [forms]![qryFamily subform]![Required_Num_Members], 
      [forms]![qryFamily subform]![PU_Eligiblity_Threshold]
  )

[GolferGuy]

INSERT INTO tblPerson ( PersonID, Attendee, DateRegistered )
SELECT 123, "Geo Green",  #10/8/2011#;

This is the code that the grid writes for what you showed as your example code. Try just a few fields this way and see what you get. Notice the SELECT just before the actual data.