G Guest Mar 10, 2005 #1 How can I open a data entry form from another form and keep on the current record? Thank You Mal
G Guest Mar 10, 2005 #2 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
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
