Too easy and I am clueless...

[Dunja]

All I want to do is create a command button to navigate through records on my form page. I created a kick ass form...but I do not like the navigating records thing on the bottom it automatically creates. So I deleted it. I used the wizard to create the command button. I see the button but it doesn't work. Something about the expression...this is what I get:

If Frame9.Value = 1 Then
me.filter=


Private Sub cmdPreview_Click()
Dim strWhere As String
If Me.FilterOn Then
strWhere = Me.Filter
End If
DoCmd.OpenReport "Report1", acViewPreview, , strWhere
End Sub

Private Sub Next_Record_Click()
On Error GoTo Err_Next_Record_Click


DoCmd.GoToRecord , , acNext

Exit_Next_Record_Click:
Exit Sub

Err_Next_Record_Click:
MsgBox Err.Description
Resume Exit_Next_Record_Click

End Sub

It won;t move to a next record...I just want a button to press to move to the next record. Can anyone help...if I am too vague let me know...

Signed,

I just want a button!

[missinglinq]

What version of Access are you using? Does any VBA code work? In the latest version of Access (2007) you have to declare the folder holding your database to be "trusted" before VBA code will work. The code you've posted is the boilerplate code the Wizard pumps out to do the job you want done, and should work.

Welcome to Bytes!

Linq ;0)>

[Dunja]

I am so sorry...I am a clueless soul, just learning and trying. I am using Access 2000. My boss is to cheap to upgrade!! I am taking a course on VBA in Sept...but I am so clueless that I feel like a kid and I am 37!!