Controls

[Floyd Forbes]

I have a control name Paid on a continuous form. In those controls I have
numbers. How do I clear all the numbers in the control with a command
button?

Floyd

 

[Steve Schapel]

Floyd,

Assuming these controls are bound to a table field, and that the Record
Source of the form is a query, you can run an Update Query to clear the
fields. The SQL of such a query would look something like this...
UPDATE YourQuery SET Paid = Null
or...
UPDATE YourTable SET Paid = Null WHERE <criteria that defines the
form's records>