G
Guest
Is there a problem with the gotorecord command in access 2007 ?
I have this code
stTEst = IsNull(Forms(scrF)!ScriptID)
If stTEst Then
DoCmd.Close acForm, scrF
Exit Sub
End If
Forms(scrF).RecordsetClone.MoveLast
zCNT = Forms(scrF).RecordsetClone.RecordCount
DoCmd.OpenForm scrF, acNormal, , strcScript, , acHidden
If zCNT > 0 Then
DoCmd.SelectObject acForm, scrF, True
DoCmd.GoToRecord , scrF, acFirst
sct1 = Forms!strMeds!SIG
zCNT = zCNT - 1
End If
I do this about 4 times I then collect the sct1 thru 4 and use them in a
report. With only 2007 I can not go pass the gotorecord statment. There are
no errors with access 2003 or XP
I have this code
stTEst = IsNull(Forms(scrF)!ScriptID)
If stTEst Then
DoCmd.Close acForm, scrF
Exit Sub
End If
Forms(scrF).RecordsetClone.MoveLast
zCNT = Forms(scrF).RecordsetClone.RecordCount
DoCmd.OpenForm scrF, acNormal, , strcScript, , acHidden
If zCNT > 0 Then
DoCmd.SelectObject acForm, scrF, True
DoCmd.GoToRecord , scrF, acFirst
sct1 = Forms!strMeds!SIG
zCNT = zCNT - 1
End If
I do this about 4 times I then collect the sct1 thru 4 and use them in a
report. With only 2007 I can not go pass the gotorecord statment. There are
no errors with access 2003 or XP