I'm trying to use this code but I get a diff error, namely 2465. But, instead of trying to use a field, I am trying to copy the contents of a string variable that I previously Dimentioned. My partial code is below:
Code:
Dim Site as string
Site = rsNewData![Station] & ", " & rsNewData![SampleDate]
MsgAnswer = MsgBox(ScoreName & ", " & Site, vbOKCancel) ' for testing only
With Me!Site
.SetFocus
.SelStart = 0
.SelLength = Len(.Value)
End With
Me.Requery
DoCmd.RunCommand acCmdCopy
So, is there a way to copy the string variable result onto the clipboard?