New record or not Dirty

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

forcefield - 13 May 2008 02:58 GMT

Hi,
I have many fields text and combo bound and unbound in a form. Is there a
situation where the form has a new record and yet dirty or any other
unexpected possibilities. I always think that when a form is new it is
invariably not dirty. I am not sure if this is true always.

In my case I would only use this condition
If myform is not dirty Then …. or If IsNewRecord = true Then …. There is
no need to test other combinations like If myform is not dirty and
IsnewRecord = true then …. Or any other combinations.

If other possibilities exist then can someone give me a situation where such
an event can occur.

Thanks

Reply to this Message

Douglas J. Steele - 13 May 2008 13:27 GMT

The new record isn't dirty until you start providing values for the fields
in it. (Remember that a record is New until it's saved.)

To check whether the current record is dirty, you use Me.Dirty.

To check whether the current record is new, you use Me.NewRecord

You could use

If Me.Dirty = False Or Me.NewRecord = True Then
...
End If

but I'm not sure of the point of the check for NewRecord.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
> I have many fields text and combo bound and unbound in a form. Is there a
[quoted text clipped - 13 lines]
>
> Thanks

Reply to this Message