Change form property with VBA

[jmk909er]

When I click in a text box on one form it opens another form using the following code:

Private Sub Reference_Number_Click()
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmProjects"

stLinkCriteria = "[Reference Number]=" & "'" & Me![Reference Number] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

The problem that I have is that after the form opens, when I click on the record selector on the bottom of the form it just shows one record and if you click forward it comes up with a blank form waiting to be filled in. If I click on "Filtered" right next to the record selector and make it unfiltered then it works fine and I can click through all my other records.

Question: Is there anything I can add to the code above that will open the form "Unfiltered" and by the way I would also like to disable the add new record next to the selector??

Thanks, Joe

[jmk909er]

Never mind, I see what I'm doing wrong