Enable a button only when form is in acFormAdd?

[dgirl1010]

I'm fairly new to VBA, and I'm trying to do an If Then statement that will allow a button on my form to becaome enabled only when the form is in data entry mode, acFormAdd, but it doesn't seem to like what I'm doing. Is this even possible?

Here's what I've tried:
If Forms!ProjectDetails!acFormPropertySettings = acFormAdd Then
Forms!ProjectDetails!cmdCommit_Click.Enabled = True
End If

 

[Remou]

How about:
[tt]Forms!ProjectDetails.DateEntry =True[/tt]

There is also a property NewRecord that you may wish to look at.

 

[dgirl1010]

Wahoo! The NewRecord idea worked! Here's what I did:

Dim intnewrec As Integer
intnewrec = Me.NewRecord
If intnewrec = True Then
Forms!ProjectDetails!cmdCommit.Enabled = True
End If


Rock on! Thanks so much!