Need Code and or directions to use command button to clear 2 fields

[kmims44]

so this is going to sound a bit confusing but hopefully you can follow and help me out. I created a form regarding parts/pricing data etc. Now one of the fields is "Add to Quote" and it is a checkbox (true/False Yes/No) option and another field is "Quote Buy QTY" which is a number. Now, I have created a command button that uses a query to find all the parts that have a true value for the "Add to Quote" field and then open a report to view the information...Essentially a quote. Now my problem is...I would like to create a command button that would return the "add to Quote" field to Null as well as the "Quote to Buy QTY" field to a blank field so that when another user uses teh database they do not have to search for records that may accidentaly still checked. Can anyone help me troubleshoot this please?

[June7]

You want to reset these two fields in all records? That is an UPDATE sql action.

Code in VBA:

CurrentDb.Execute "UPDATE tablename SET [Add to Quote] = False, [Quote Buy QTY] = 0;"

[kmims44]

Thanks very much worked perfectly! Can you also tell me how to create a user-friendly search feature...the find record command brings up the find/replace tool but I was wondering if there was a better way to do this

[June7]

For parameterized query approach (query would be the RecordSource of form), review tutorials at http://datapigtechnologies.com/AccessMain.htm especially 'Build a Custom Filter in Your Form' and 'Creating a Basic Search Form' in Access Forms: Tips and Techniques section.