Error with GoToRecord

[gsforfree]

Hi,

When I run

Public Sub getRecord(recNum)
On Error GoTo Err_getRecord

DoCmd.GoToRecord , , acGoTo, recNum

Exit_getRecord:
Exit Sub

Err_getRecord:
MsgBox Err.Description
Resume Exit_getRecord

End Sub

in the specified form code window, I receive an error that states "You cannot go to the specified record." It seems that the syntax is correct, is there a setting on the form I'm missing?

 

[Andrew Fergus]

Hi

From the Access/VBA help :

When the Record argument is Go To, Access moves to the record with the number equal to the Offset argument. The record number is shown in the record number box at the bottom of the window.

Is the value in recNum larger than the number of records in the table / form? Can you move away from the current record once it is saved? (i.e. is it a referential integrity problem?) If not can you explain what you want to achieve?

Andrew