getting a aalendar to control date record

G

glen

Access 2003.

I want to be able to use a calendar to select a date record. I have a field
on the form called "adate" that I would like the calendar to control. When I
select a date on the calendar I want the "adate" to change to the selected
date.
 
W

Wayne-I-M

Use the AfterUpdate event of the calender to set the vaule of your [adate]

Private Sub CalendarName_Updated(Code As Integer)
Me.adate = Me.CalendarName
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Formats & Display 5
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Updated records in forms 1
Access 2003 Calendar Control 11.0 value update 2
Remember the Date 4
Calendar Control on a form 2
Make Calendar Control Invisible 1
Can some one modify the thirdfriday code to get me the following d 2

Top