I am trying to make my own previous and next button on my form and I also need to change the filter when this happens. The filter when the form opens is [Reference Number] = "" and when I press the next button I want the filter to change to [Completed Projects] = 0
I put in:
Private Sub Command79_Click()
Me.Filter = "[Project Completed] = 0"
DoCmd.GoToRecord , , acNext
End Sub
And it kinda works but wont go past record 2
How can I write it in VBA? I have tried many things and nothing seems to work. Form is called frmProjects
Any Ideas?? Thanks, Joe