View Single Post
  #3  
Old November 13th, 2004, 01:26 PM
eb1mom
external usenet poster
 
Posts: n/a
Default

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.

"PC Datasheet" wrote:

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