help switching forms

[armoredcars]

I have a single table and need to switch from the same record in form A to to the same record in form B based off the same table. The problem is that something is always the same as itself, the OrderID matches the OrderID for every record so it always sends me to the first record.

 

[Luddite Lad]

The following might be what you are looking for;

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "FRM_FormB"
    
    stLinkCriteria = "[LinkingID]=" & Me![LinkingID]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[armoredcars]

Awesome! Thanks.