I have searched the forum for this problem, and the related issues have not helped. The below code is rather simple, but access will not allow me to insert the Property_ID into the form. Error: You can't assign value to this object. Any helpful advice would be much appreciated. Thanks.
Dim stDocName As String
Dim stLinkCriteria As String
Dim Property_ID As Integer
Property_ID = Me![PropertyID]
stDocName = "Leave Message"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.GoToRecord , , acNewRec
Me![PropertyID] = Property_ID
Dim stDocName As String
Dim stLinkCriteria As String
Dim Property_ID As Integer
Property_ID = Me![PropertyID]
stDocName = "Leave Message"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.GoToRecord , , acNewRec
Me![PropertyID] = Property_ID