Let's set it to no and do the code that way. When we are done I would like for you to explain all of the code to me to help me learn this better. Again Thanks
Thank you for what you have done so far. The "Yes" part looks good but the "No" will let you enter a duplicate number. I think it should clear it at go to new record.
Sorry this not working. It's telling me that any number that I enter is a duplicate. When I do enter a number that is a duplicate it works like it should. It's not letting me to add a new number.
Private Sub TransactionNumber_AfterUpdate()
Dim lngNumber As Long
lngNumber = Me!TransactionNumber
Me.Undo
With Me.RecordsetClone
.FindFirst "TransactionNumber = " & lngNumber
MsgBox "Transaction Number " & lngNumber & " Has Already Been Entered" _
& vbCr...
Ok that works perfect!!! Now how can you get it to go to the Transaction Number if it is a duplicate? Then after you get this to work will you explain it to me so I know how this works? Thanks for taking the time to help me with this.
I'm new to vba and access. Im looking for some to code this and explain it line by line so I can understand what it does. I learn the best from detail examples. I know they are a lot to this code to get it to work. I been looking for over a week. I do know that they are a thousand ways to do the...
I'm looking how to look for a duplicate in a form and display a msgbox if it's true and go to that Transaction Number or enter new ticket if false. I have a table named InHouseAccount a field named InHouseAccountID set to autonumber and a field named TransactionNumber Data type set to number and...