Opening a form with a varying record number

armoredcars

New member
Local time
Today, 03:17
Joined
Jun 25, 2007
Messages
9
I have a table "Orders" linked to two forms, "Summary" and "Complete". I want to be able to click on a button from Summary and have it open the same record in the Complete form.
I have 'Access 2007; The Missing Manual' but all it tells how to do is open a predefined record.
 
This give you any ideas?

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmEditRes"
stLinkCriteria = "[ResNum]=" & Me.txtResNum

DoCmd.OpenForm stDocName, , , stLinkCriteria
 

Users who are viewing this thread

Back
Top Bottom