Clearing a text box bound to table without erasing data in that field
Posted on 2005-04-05
I have a form with several text boxes that are bound to fields in a table. When I first load the form I would like to have the boxes empty until someone selects a user id, from a combo box, to return records from the table. Also there may be times during normal operation when I would like to clear the information just to make the form more presentable. At first I was setting the value property of the text box to = " ", but since the box's were bound to the table this was overwriting the information in that field. Does anyone have a good way of clearing a text box bound to a table without erasing the info, or any other suggestions?