Calendar control default value

[Lee Hunter]

What is the correct method or syntax to accomplish:

Cal.Value = IIf(IsNull(Date_In), =NOW(),_ Date_In.Value)

Where Cal is tha ActiveX calendar control and Date_in is
a text box bound to a date field in the DB.

That is to say, if the current record has no date, start
the calendar with today's date.

Thanks for your assistance.

 

[Danny]

Why not bind your calendar control to the date field in the
record source?

 

[Guest]

I don't do that because the form is used to both update
and add records. For new records I need the user to pick
the date from the calendar. For update the date remains
the same.

Thanks for the reply.