How do I tell if I'm on a "new" record in a form?

[gaffonso]

I need to implement some default-setting behavior in a form. For various reasons, I can't use standard field defaults or the DefaultValue property of my controls so I'll need to program the solution.

What's the best way to tell if the current record on a form is a "new" record?

Thanks!

- Gary

 

[gaffonso]

Er, feeling a little dumb, just answered this for myself.

The NewRecord property of the form will return true if the form is currently displaying a new record. The code would look like this:

If Me.NewRecord Then
' do some stuff based on having a new record
End If

- Gary