Calendar Deault to Todays Date

[Bill]

I am using a calendar on a form. What code is needed to
have the calendar focused to todays date? What code would
be needed so the calendar would be focused on the last
date entered?

 

[PC Datasheet]

Bill,

To make today's date the fefault, put this code in your form's OnActivate event:

Me!NameOfCalendarControl.Value = Date()

For part 2 of your post, you would need to save that date somewhere and then
modify the above code to:

Me!NameOfCalendarControl.Value = DLookup.... <Wherevever you saved the date>


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel