Linking Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I open a data entry form from another form and keep on the current
record?


Thank You
Mal
 
Hi, Mal.

Assuming that both forms have a control that displays the record's primary
key:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "YourForm"

stLinkCriteria = "[YourPrimaryKey]=" & Me![PrimaryKeyControlOnCurrentForm]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Hope that helps.
Sprinks
 
Back
Top