I found another work around. I set up the text box with the lookup to do the lookup when clicking on it and set the "0" text boxes to null when on got focus using code Texthere.Text = "". The 0's will still display but not when the user is going to update the field so that way they can't make an error because of it.



Now I need to change other feature. I need that the record only gets saved when the user clicks on save record command button