Access Calendar

[LisaM.]

I am trying to build a form in MSAccess where clicking on a date in the activex calendar produces a list
of records with that date. When I click on the date I get all the records not just the date selected. I am a beginner who really needs some guidance on this. Thanks

create 2 forms, "frmCalendar" (with the activex calendar) and "frmRecords" whose record source is an entire table of records with various dates...

in frmCalendar, in the click event of the calendar, put a line of code similar to this one...



DoCmd.OpenForm "frmRecords", WhereCondition:="[date] = #" & _
CStr(ActiveXCalendar.date) & "#"





I haven't tested this exactly, but it should work. [Date] is the name of the field that holds the date in the table.