View Single Post
  #4  
Old April 21st, 2008, 03:14 PM posted to microsoft.public.access.forms
Question Boy[_2_]
external usenet poster
 
Posts: 179
Default form properties vs. VBA

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




"Klatuu" wrote:

You can also determine if it is a new record with

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


--
Dave Hargis, Microsoft Access MVP


"Question Boy" wrote:

Answer my own question.

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

QB





"Question Boy" wrote:

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