Oct 22, 2001 #1 tetorvik Programmer Joined Sep 6, 2001 Messages 13 Location FI Is there any easy way to determine if a user has changed a data on a form? Thanks
Oct 22, 2001 #2 WHM Programmer Joined Jul 24, 2001 Messages 48 Location US Yes. Create a global variable " Dim Changed As Boolean" and then attatch code to all of the controls_Changed properties: Option Explicit Dim Changed As Boolean Private Sub Text1_Change() Changed = True End Sub Private Sub Text2_Change() Changed = True End Sub etc etc LOL Hunter Upvote 0 Downvote
Yes. Create a global variable " Dim Changed As Boolean" and then attatch code to all of the controls_Changed properties: Option Explicit Dim Changed As Boolean Private Sub Text1_Change() Changed = True End Sub Private Sub Text2_Change() Changed = True End Sub etc etc LOL Hunter