undo or clear information

[Allan Murphy]

Sandrao

Using the On Load Event of your form set each field to be cleared to NULL
e.g. Me!field_to_be_cleared = NULL

Allan

 

[Guest]

I have a small form that I use to create a report every month. Some of the
information in those field carries on every month but other fields change
each month. How can I have just certain field cleared of the information
without deleating the entire record? Can a query update a field with an
"Null" value. Or can this be done through VB? I just want the clear
informatin in certain fields of a record and keep others.

Sandrao

 

[UpRider]

Sandrao, do you want to keep the existing record and add a new 'duplicate'
each month?
Or do you want to just update the existing record with the new information
for the new month?

UpRider