"Calendar" Form to insert Month and Year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a VB calendar to insert dates on many forms. It works very
well. However on a monthly budget form I only need month and year. I am
using a calendar form and formating date field mmm/yyyy. When user selects
month and year and clicks enter, it inserts correctly. BUT, the days section
of the calendar is confusing users. Is there a "calendar" form without days?
thanks
 
Use two comboboxes, the first for year and the second for month. Put the
following code in the AfterUpdate event of the month combobox:

Me!MydateField = Me!NameOfMonthCombobox & ", " & NameOfYearCombobox
 
Thank-you for your help. Form is now much less confusing and users are
pleased. I appreciate you taking the time to answer my post.
 
Back
Top