clear values on form

[klp via AccessMonster.com]

I have a subform that has a various field(checkbox) & a count field(text box)
both are bound. The user goes in, selects their order # & puts in their
information in the fields mentioned above, then clicks the preview button and
gets the report. What I need is to clear these 2 fields after the print
button has been clicked. These 2 fields are stored in a table, but they are
soley used for reporting purposes and they need to be clear each time the
user selects an order.

Thanks in advance!

Kim

 

[klp via AccessMonster.com]

BTW - I tried running an sql statement to update or delete the values from
just those 2 fields but it prompts me w/ a message indicating that I will be
updating/deleting this information. I do not want message box to appear if
possible.

 

[klp via AccessMonster.com]

Disregard this message. I actually figured it out, all it took was a little
talking it out. Thanks for your time!

BTW - I tried running an sql statement to update or delete the values from
just those 2 fields but it prompts me w/ a message indicating that I will be
updating/deleting this information. I do not want message box to appear if
possible.

I have a subform that has a various field(checkbox) & a count field(text box)
both are bound. The user goes in, selects their order # & puts in their

[quoted text clipped - 7 lines]

Kim