Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HowTo: Clear Form Fields after Search and Edit. 1

Status
Not open for further replies.

bsupport

Programmer
Dec 20, 2000
53
US
How to I clear form fields (record source is a query), once I have searched for and updated a record. I search from a combo box selection. I edit 3 or 4 fields. Then, I want to clear my screen, (the fields) and search for another record to update. Does anyone know how to clear (blank-out) form fields? I should note that some are text and some are combo boxes.

Your assistance is greatly appreciated.
-Thanks
bsupport
 
Rickspr,

Thanks for the assistance. But I noticed after update about five records that this clears not only the form fields but also the data in my table. I only want to blank-out the form fields. Do I need to textbox fields for the and then initialize them to the value of the table fields and use these values on the form in order to prevent deleting data from my table?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top