Hi Joan,
I need to work a little with this because the DAO was checked. But here is
another snipped of code that has trouble.
Option Compare Database
Option Explicit

Private Sub Detail_Click()
   Dim MySSN As Control
   Dim ctlList As Variant

   SetctlList = Me!SSN
   ctlList.Requery
End Sub

It balks at the "SetctlList" line. This is not something that I wrote, but
something inserted interactively by I forgot what. The database is a few
years old, and I don't know every bit of code in there. I'm not that good
and depend a lot on the usergroups.
Again, many thanks -- wish you worked in our place :)
Brigitte

Joan: I keep on running into problems with code. Most of my code comes from
the user groups and worked great in my A97, but I don't understand the
syntax, thus I can't repair things. Here is another piece that won't work:
Option Compare Database
Option Explicit

Private Sub Form_GotFocus()
DoCmd.GoToRecord , , acNewRec
End Sub

Private Sub txtTypeContribution_NotInList(NewData As String, Response As
Integer)
Dim db As Database, rs As Recordset
   Dim strMsg As String
   strMsg = "'" & NewData & "' is not an available option. "
   strMsg = strMsg & "Do you want to add the new donation type? "
   strMsg = strMsg & "Click YES to add the new donation type or NO to
select an existing one it."
   If MsgBox(strMsg, vbQuestion + vbYesNo, "Add new type?") = vbNo Then
       Response = acDataErrContinue
   Else
       Set db = CurrentDb
       Set rs = db.OpenRecordset("tblTypeContributionLookup",
dbOpenDynaset)
       On Error Resume Next
       rs.AddNew
           rs!TypeContr = NewData
       rs.Update

       If Err Then
           MsgBox "An error occurred. Please try again."
           Response = acDataErrContinue
       Else
           Response = acDataErrAdded
       End If
   End If
End Sub
Runs into Error 13 at Set rs = db.OpenRecordset("tblTypeContributionLookup",
dbOpenDynaset)

I checked the Microsoft DAO 3.6 Object Library, helps with the original code
I had problems with (toggle Bypass Key), but not this one. I checked in the
original A97 dbase wich has Microsoft DAO 3.51 Object Library. I changed
from 3.6 to 3.51, still the above doesn't work.  I developed and managed
several fairly sophisticated databases in A97 with a lot of help from texts
and user groups, but now I'm stumped if all that code doesn't work any
longer. Any ideas what a non-programmer like me can do?
Thanks
Brigitte