[AccessD] Data copied to both tables????

Keith,

    On a trial conducted at this end (Access XP on Win XP), your code is found to work OK. Only the temporary table (tempfax_Admin) is getting populated, not the original blank table (tblfax).

    If still stuck up, you might like to send a zipped extract of the pruned down file, containing the problem forms, table & code, for further examination.

Regards,
A.D.Tejpal
--------------

  ----- Original Message ----- 
  From: Keith Williamson 
  To: 'Access Developers discussion and problem solving' 
  Sent: Friday, August 27, 2004 21:09
  Subject: [AccessD] Data copied to both tables????


  Can someone please tell me why the code below adds data to BOTH the tblfax
  table AND the (tempfax_& currentuser) table??????

  I'm at wits end here.  All the fields being added to recordset "mytable2"
  are from unbound fields in the open form.  The intent here is to copy an
  empty table "tblfax" (which has no data), and call it "tempfax_" & current
  user.....copy the forms data to this table...and use it for the data source
  for a report.  For some reason...the data is being copied to both tables.  I
  can't understand why.  Any ideas???




  Dim db As Database
      Dim stDocName As String
      Dim mytable2 As Recordset
      Dim sqlstring As String
      Dim recSource As String

      Set db = CurrentDb

      DoCmd.CopyObject , "tempfax_" & CurrentUser, acTable, "tblfax"
      Set mytable2 = db.OpenRecordset("tempfax_" & CurrentUser)
      
      With mytable2
      .AddNew
          ![faxto] = [TempFaxTo]
          ![phonenum] = [tempphone]
          ![faxfrom] = [TempFrom]
          ![faxnum] = [TempFaxNum]
          ![Pages] = [TempPages]
          ![urgent] = [TempUrgent]
          ![review] = [TempForReview]
          ![comment] = [TempPleaseComment]
          ![reply] = [TempPleaseReply]
          ![message] = [TempMessage]
      .Update
      End With


  Thanks,

  Keith E. Williamson
  Ashland Equipment, Inc
  phone # (410) 273-1856
  fax #     (410) 273-1859