Hi Micron, the same recordset populates all the text boxes that need to be compared. The user has 3 options that i foresee with the text boxes, they can bring up a blank record to start a new product, bring up an existing record and edit its details in the text boxes, or use the record as he originally entered it displayed in the text boxes. Its these Last two possibilities that i need help with, how do i tell if the record loaded in the text boxes is as was originally loaded or if he had to adjust it. Do you have a different way?
I did have another thought last night after i had stopped for the night kind of like Steve's concept but maybe simpler. What if i use the on-change event. I haven't tested or tried it yet but my thought was if i put a hidden checkbox on the screen, then added to the on-change event of each of the text boxes to make the checkbox "true". Something like-
Code:
Private Sub txtLength_Change()
Me.ckrecord = True
End Sub
Then when the user tries to change to a new record i could have something like this to direct the record-
Code:
Private Sub recordqualify()
If txtproductID = "" Then
recordaddnew '-------------its a new record
ElseIf Me.ckrecord = True Then
recordedit '---------------its an existing record that has been adjusted
Else
'--------------------------GoTo next record,no changes were made to this one
End If
End Sub
Not sure what you may have had in mind as another option but I would love to hear it. And i did use some of your code in this project, the text boxes are being validated with your "HasNoData" function, Thanks for posting it, its working like a charm.