clearing data

[natalie]

i have created a button which allows me to add a new record on a form which
is saved in the database. i want to edit this code for the button to allow
me to add a new record but only clearing out the detail section on the form.
i want the header section of the form to stay the same. how can i do this?
Many thanks x

 

[NetworkTrade]

not sure what is in header vs detail so one can't completely answer; going to
a new record maybe....

 

[vbasean]

your controls in the header are more than likely linked to the
datasource thus they revert to null values on going to a new record.
I'm assuming you want those values to stay the same for the new
record. If that's the case you are talking about "Default" values
which can be set in the form design mode and always show the value you
want.

As for setting default values on the fly without going to default
mode, that's a bit more complex.