Shrink code for singe parts number creation without going through entire db

[RosaCat]

Sorry about that. I just wanted to make sure you had all the information you needed and since I don't know what that is, you got it all.



I actually do need the function on post 21. How do I incorporate this into my code?

[pbaldy]

The function would go into a standard module and you'd call it like I showed in post 21:

Me.txtMfgPartNumber = ReplaceSpecial(Me.txtMfgPartNumber)