Removing a record

E

EH

Hello.

I have a table containing 2 fields. These fields are used when the print
report button is pressed. There is only ever one record in this table, it
changes alot.

I need this button to, after the report is printed, to clear out the 2
fields (and the record as a whole), and return for user input to print
another report using the next set of information they enter.
 
D

David C. Holley

Just use an UPDATE query to set the values to NULL or "" depening on the
field properties set in the underlying table.
 
Top