form properties vs. VBA

[Question Boy]

I have a form which I set to allow additions (No edits, No Deletes). The
form only has 1 control - cotinuous form. On the form I have the control's
x2 click property calling Allen Browne's popup calendar. My problem is that
although the user cannot manually make changes to the data (a date) entered
in previously, the x2 click event still get trigerred and the popup calendar
can make the modification. How can I disable the event/popup when it is not
a new entry?

Thank you,

QB

 

[Question Boy]

Answer my own question.

By comparing the CurrentRecord to teh RecordsetClone.RecordCount I can
enable or not the popuo cal.

QB

 

[Klatuu]

You can also determine if it is a new record with

If Me.NewRecord Then
'It is a new record
End If

 

[Question Boy]

Thank you Klatuu. I wasn't aware of that approach. Simpler is better (in my
mind)!

 

[Klatuu]

You won't find many people simpler than I <g>