yes all fields and properties are the same in both tables.
Is it because I am trying to copy the current records on the opened form?
pthursby@spsu.edu (PaulT) wrote in message news:<814613e.0402130608.6b2ec65a@posting.google.c om>...[color=blue]
> Also, what is the error message when debug 'hits' that line?
>
> -Paul
>
>
jprma@tin.it (Paolo) wrote in message news:<9f41a860.0402110507.60dc7f7e@posting.google. com>...[color=green]
> > Yes, both tables have exactly the same fields. I still don't undertand
> > where is the problem.
> >
> >
> >
pthursby@spsu.edu (PaulT) wrote in message news:<814613e.0402091851.9757fc3@posting.google.co m>...[color=darkred]
> > > Does your 'RECORDS' table actually have a SSN field?
> > >
> > > Also, make sure you don't have SSN as a number type in one place, and
> > > text in another (like forms usually have).
> > >
> > > -Paul T.
> > >
> > >
> > >
jprma@tin.it (Paolo) wrote in message news:<9f41a860.0402090156.35bc58c@posting.google.c om>...
> > > > Thanks. I have added the same code behing a new button of my form but
> > > > I have a debug problem with:
> > > > MyRs!SSN = Forms!APPLICATIONS!SSN
> > > >
> > > > I am working on a form named REPORTS with a record source to the table
> > > > named REPORTS and trying and only trying to copy the same records to a
> > > > different table, named APPLICATIONS. I believe there must be a problem
> > > > with the MyRs line.
> > > >
> > > > Note that I am working on the same database.
> > > >
> > > > Any idea? Thanks.
> > > >
> > > >
pthursby@spsu.edu (PaulT) wrote in message news:<814613e.0402051339.1aeee1c2@posting.google.c om>...
> > > > > Export?
> > > > > Why not just open a recordset on the "REPORTS", do addNew, and do the
> > > > > same thing?
> > > > >
> > > > > Even if it's in another database, use that other database's name
> > > > > instead of CurrentDB()
> > > > >
> > > > > -Paul T.
> > > > >
> > > > >
jprma@tin.it (Paolo) wrote in message news:<9f41a860.0402040200.6fda3ed5@posting.google. com>...
> > > > > > I know I should not be doing this, but I find it very useful. I have a
> > > > > > database in Access which stores data for a small company. Sometimes we
> > > > > > need to add similar information to different tables. Currently I am
> > > > > > already doing something similar by copying certain records into the
> > > > > > same table. The only thing that changes is one field.
> > > > > >
> > > > > > Please look at the code:
> > > > > >
> > > > > > Dim MyDb As DAO.Database, MyRs As DAO.Recordset
> > > > > > Dim strCode As String
> > > > > > Dim strFilter As String
> > > > > > Set MyDb = CurrentDb
> > > > > > Set MyRs = MyDb.OpenRecordset("APPLICATIONS")
> > > > > > MyRs.AddNew
> > > > > > MyRs!SSN = Forms!APPLICATIONS!SSN
> > > > > > MyRs!FNAME = Forms!APPLICATIONS!FNAME
> > > > > > MyRs!LNAME = Forms!APPLICATIONS!LNAME
> > > > > > MyRs!RECEIVED = Forms!APPLICATIONS!RECEIVED
> > > > > > MyRs!CLOSED = Forms!APPLICATIONS!CLOSED
> > > > > > MyRs!INITIALS = Forms!APPLICATIONS!INITIALS
> > > > > > MyRs.Update
> > > > > > strCode = DMax("[ID]", "Applications")
> > > > > > strFilter = "(([ID] = " & strCode & ")) "
> > > > > > DoCmd.ApplyFilter , strFilter
> > > > > > Me.Refresh
> > > > > > Me.CODE.SetFocus
> > > > > > If IsNull([code]) Then
> > > > > > MsgBox "Please enter the Claim TYPE!. ", vbOKOnly
> > > > > > Me!CODE.SetFocus
> > > > > > End If
> > > > > >
> > > > > > As you will notice there may be one field with no data. In that case
> > > > > > the input box will come up and users can type the required info.
> > > > > > Any help?
> > > > > > As was now wandering if is possible to export the same information
> > > > > > into a different table, let's say named REPORTS. The code should copy
> > > > > > the data i have typed in the active form, and paste in into this other
> > > > > > table.[/color][/color][/color]
Duplicating data to different tables 
