Controls

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

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
 
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>
 
Back
Top