Clearing data in records

R

Rudi

Hi,

How do I clear some data in a spesific record. Say I have a from that enters
data into a table. Every time I open the form, all the data in the first
record must be erased.

Thanks!
 
R

Rick B

Why would you erase the 'first' record each time you open a form? Also,
what is the 'first' record? Depending on the sort, 'first' could mean a lot
of things.
 
J

James Goodman

An update query should do this, although you will need to be careful to make
sure you 'clear' the correct record as the order could change depending on
the data in the table & the sort order.

Within your update query set number fields to NULL and text fields to ""
(Zero Length String) where applicable.
 
Top