Add data to table with VBA [closed]

Question

Having trouble updating a table in VBA using the Set rst= CurrentDb.OpenRecordset, could someone please help me. I am not sure how to organize my field in this statement:

 Set rst = CurrentDb.OpenRecordset("t_Evaluation", dbOpenDynaset, dbSeeChanges)
  ExecutionLeadOrg, TitleID, t_Evaluation.EvalTypeID, SectionID, LOBEvaluation, LOBlegalApprover, LOBcomplianceApprover,LOBAdditionalApprovers,
  LOBcompImpact , LOBcompImpactDESC, LOBLegalMemoLink, HiLevelLOBTimingSumm, HiLevelLOBCostSumm, LOBStrategicImpactSumm, RuleHiTimingSumm, RuleHiCostSumm
  PlannedFunding , LOBInternationalImpact, LOBIntnalImpactDESC, LOBcustomerImpact, LOBCusAudienceImpact, LOBassociateImpact, EarlyArchLeansLink
    ' here you need to add each of your fields from the form
  rst.AddNew
  rst.Update

Answer 1

So why do you have the fieldnames in there. What are you trying to accomplish? The OpenRecordset command, when using a Source type of Table Name (string) will get all the fields.