I have two problems, I installed access 2007 when I have been using XP
before. I have a program written in access 2003 mdb and I succesfully
converted it to adp. It works well in XP and 2003 office But This command
will not work in 2007
docmd.gotorecord.recname.acnext(or first or any) Even if it follows the
selectobject.acform.recname.true (rec name is a name of a form).

My second program is I had written a utility to save a report as a snap shot
automaticaly into a folder. Even downloading the snapviewer I still cannot
create the report. The error is the format is not available. I can read the
reports that are saved by office Xp which still works just fine. If I use
..pdf office 2007 works but ofcourse office XP or 2003 have no support for
this out put format. Sorry about the length but please HELP!

I guess noone will help so I will answer my own question. I still do not know
why the gotorecord does not work so I deviced a long work around and here it
is.

Set stScrpt = Forms(scrF).RecordsetClone

zCNT = stScrpt.RecordCount

'MsgBox "My form contains " _
& zCNT _
& " records.", vbInformation, "Record Count"

If zCNT > 0 Then
COUNT = 1 ' used as a test to open script form
stScrpt.MoveFirst
sct1 = stScrpt.Fields.Item("SIG")
'MsgBox sct1
zCNT = zCNT - 1
End If

Here movenext cycles through the rest of the records and obtains the
information without a problem. I am sure the is a catch but I am happy that
it does work now

"MUSIWA" wrote: