We have an Access 2007 SP2 form that is based on recordset and has an image associated with each record but when use on click event to select that image, it seems to only using data from first record on form not the selected one yet when do exact same code on button, it works fine. This use to work and only thing we can see is that it worked on computer without SP2 of office 2007. Has anyone else seen this issue? Thanks, Joe
Dim stDocName As String
Dim stLinkCriteria As String
Forms!frmMainMenu!txtImagePath = Me.AdImage
stDocName = "frmEnlargeImage"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Dim stDocName As String
Dim stLinkCriteria As String
Forms!frmMainMenu!txtImagePath = Me.AdImage
stDocName = "frmEnlargeImage"
DoCmd.OpenForm stDocName, , , stLinkCriteria