I have a linked SQL Server table in my database.  I can edit and add
records to this table using bound forms.  However, in my database I
have unbound forms, which add new records.  My problem is I've been
unable to open the table with code.

My previous code was the basic:

    Set mydb = CurrentDb
    Set myTable = mydb.OpenRecordset("tblReportData", dbOpenTable)

    With myTable
         .AddNew
          ![Review Date] = txtReviewDate
          ![Analyst] = cboAnalyst
          ![Report Name] = cboReportName
          ![Report Date] = txtReportDate
          ![Review Time] = txtReviewTime
          ![Comments] = txtComments
          .Update
          .Close
      End With

This code no longer works.  I made sure the table name was the same as
the linked table but it still does not work.  I have no idea why this
is not working.  I believe I need to set up some kind of connection to
the SQL Server Database but I really have no idea what I'm doing
here.

Does anyone know how to open a SQL Server linked table for additions
with VBA code?