I believe that would only set the value of the calendar to being the
current
date, when I need it to show the value of the TransDate field on existing
records and the current date on newly created, empty records (until I
choose
a value for TransDate). What does OnCurrent mean? Wouldn't that apply to
the
existing records and not just the new ones?
"tkelley via AccessMonster.com" wrote:
> Holy cow, I botched that one. I got a little mixed up.
>
> Have you tried putting your calendar8.value=date() in your OnCurrent
event
> for the form? That's where I meant to go with this.
>
> tkelley wrote:
> >If you look at the properties/events of a calendar control, they aren't
all
> >listed. However, if you go into the VBA code window and select your
calendar
> >as the object, you'll see additional events that apply to calendars in
the
> >events dropdown.
> >
> >In that dropdown you can select OnCurrent. Then you can put your code
to set
> >the calendar.value property.
> >
> >Try that ...
> >
> >>I have added a calendar control to my data entry form in Access 2003.
It's
> >>called Calendar8. I have it tied to a field in my main table called
> >[quoted text clipped - 15 lines]
> >>far)? When I enter transactions, I roughly enter them in date order,
oldest
> >>to newest. Thanks!
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200812/1
>
>
|
