Move to a record on a form based on another forms data
Posted on 2015-02-06
This code is working to find the record in the other form but the records are filtered and it only shows one record... I want the code to bring me to the record on that form but not be filtered and show all of the other records..
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "MasterCamp"
stLinkCriteria = "[ID]=" & Me![ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Close acForm, Me.name