Calendar Default Date

[Guest]

Hi,

I'm using a Calendar control in my form that is activated when the user
clicks either the StartDate (combobox) or the EndDate (combobox). The
calendar is still opening with 2005 dates. I've searched the other posts and
tried the suggestion that I found, but it is not working. Can someone tell
me another way this might be done? Here is the code:

Private Sub Form_Open(Cancel As Integer)
Me.Calendar.today
End Sub

As always, many thanks for your help!

Arlene

 

[Guest]

Arlene:

Try using the form's Load event procedure rather than its Open event. The
latter is probably too early in the sequence of events which occur when a
form is opened.

Ken Sheridan
Stafford, England

 

[PC D]

Change Me.Calendar.today To:
Me!Calendar.Value = Date()

 

[StopThisAdvertising]

"PC D" <[email protected]> schreef in bericht
--

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1175 users have come to me from the newsgroups requesting help '1175 users ????
(e-mail address removed)

--
To Steve:

Why PC D this time? Why not PCD anymore, or Access Resource or Help available or why not just PC DataSheet?
You think that changing names is changing anything?
Why don't you just get lost? No-one wants your advertising/job hunting here!
Over 600!! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R

 

[Guest]

Hi Ken,

Your suggestion worked great. Many thanks!

Arlene