Originally Posted by
armyofdux
...I also found copy/paste tends to screw things up as opposed to typing stuff out...
It does, indeed! That's how you get things like this
Code:
Private Sub FY_Click()
Me.FY = vbNullString
End Sub
End Sub
where you've pasted one Sub into the middle of another, existing Sub! If you'd posted more of you code, here, you'd undoubtedly have something like this:
Code:
Private Sub SomeOtherControlName_Click()
Private Sub FY_Click()
Me.FY = vbNullString
End Sub
End Sub
which can give you some really strange Error Messages that can make it difficult to debug your code! I'm not saying don't ever copy and paste, but writing code is a very precise endeavor, and consequently you have to be very precise in inserting code into code!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007