"Calendar" Form to insert Month and Year

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
 
P

PC Datasheet

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
 
G

Guest

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.
 

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

Top