Check to see if form is blank?

[GregSmith]

How can I check to see if something has been added to a form? When you open a form and enter in no entries, it's considered blank till you select an option from a drop down box or enter text in a field. Is this correct?

 

[DBL]

I use the autonumber field to assess whether the record has been created or not. As soon as you make an entry, the autonumber is assigned, before that it's a clean entry:

If IsNull (Me.AutnoNoField) or Me.AutnoNoField = 0 Then....


HTH

 

[Elana]

Or, you can use

If Me.NewRecord = True then...

 

[Rich]

If Me.NewRecord Then
will fire as soon as the form moves to a new record even if no fields are filled or selected. You don't need =True either.