Hi.

When the user selects the date with the Calendar control, the following code
would update the date in the text box:

   Me!BeginningDate.Value = Me!SelectDate.Value

... where BeginningDate is the name of the text box to display the date, and
SelectDate is the name of the Calendar control.

To make the Calendar control appear:

   Me!SelectDate.Visible = True

To make the Calendar control disappear:

   Me!SelectDate.Visible = False

For a working example of the Calendar control's use in a form, including VBA
code, you may download the Developer Solutions database in the bapp2000.exe
sample file from the following Web page:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bapp2000/html/m
dbdownload.asp

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses:  known newsgroup E-mail harvesters
are Ripley@CASInternet.Net and scott@ripleysoftware.com

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions.  Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.