View Single Post
  #2  
Old November 12th, 2004, 03:28 PM
PC Datasheet
external usenet poster
 
Posts: n/a
Default

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

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"eb1mom" wrote in message
...
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