form properties vs. VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Question Boy - 21 Apr 2008 14:36 GMT

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

Reply to this Message

Question Boy - 21 Apr 2008 14:42 GMT

Answer my own question.

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

QB

> 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
[quoted text clipped - 7 lines]
>
> QB

Reply to this Message

Klatuu - 21 Apr 2008 14:50 GMT

You can also determine if it is a new record with

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

Signature

Dave Hargis, Microsoft Access MVP

> Answer my own question.
>
[quoted text clipped - 14 lines]
> >
> > QB

Reply to this Message

Question Boy - 21 Apr 2008 15:14 GMT

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

> You can also determine if it is a new record with
>
[quoted text clipped - 20 lines]
> > >
> > > QB

Reply to this Message

Klatuu - 21 Apr 2008 15:16 GMT

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

Signature

Dave Hargis, Microsoft Access MVP

> Thank you Klatuu. I wasn't aware of that approach. Simpler is better (in my
> mind)!
[quoted text clipped - 23 lines]
> > > >
> > > > QB

Reply to this Message