combo box in a user form

I have created a form containing a combo box using the following code:
With cmbMonth
..AddItem "Jan"
..AddItem "Feb"
..AddItem "Mar"
..AddItem "Apr"
..AddItem "May"
..AddItem "June"
..AddItem "July"
..AddItem "Aug"
..AddItem "Sept"
..AddItem "Oct"
..AddItem "Nov"
..AddItem "Dec"

It works great except once an entry is made, the contents in the form fields
cleared, and another entry is to be made, the combo multiplies showing a
doubled list of months. How can I keep these from doubling.

Add the ".clear" after the first line.

With cmbMonth
.Clear
.Additem "Jan"
....


Regards,
Edwin Tam
[email protected]
http://www.vonixx.com


"juliejg1" wrote:

> I have created a form containing a combo box using the following code:
> With cmbMonth
> .AddItem "Jan"
> .AddItem "Feb"
> .AddItem "Mar"
> .AddItem "Apr"
> .AddItem "May"
> .AddItem "June"
> .AddItem "July"
> .AddItem "Aug"
> .AddItem "Sept"
> .AddItem "Oct"
> .AddItem "Nov"
> .AddItem "Dec"
>
> It works great except once an entry is made, the contents in the form fields
> cleared, and another entry is to be made, the combo multiplies showing a
> doubled list of months. How can I keep these from doubling.

When I do this I get the following error message:

Complie error: Expected Function or variable

"Edwin Tam" wrote:

> Add the ".clear" after the first line.
>
> With cmbMonth
> .Clear
> .Additem "Jan"
> ....
>
>
> Regards,
> Edwin Tam
> [email protected]
> http://www.vonixx.com
>
>
> "juliejg1" wrote:
>
> > I have created a form containing a combo box using the following code:
> > With cmbMonth
> > .AddItem "Jan"
> > .AddItem "Feb"
> > .AddItem "Mar"
> > .AddItem "Apr"
> > .AddItem "May"
> > .AddItem "June"
> > .AddItem "July"
> > .AddItem "Aug"
> > .AddItem "Sept"
> > .AddItem "Oct"
> > .AddItem "Nov"
> > .AddItem "Dec"
> >
> > It works great except once an entry is made, the contents in the form fields
> > cleared, and another entry is to be made, the combo multiplies showing a
> > doubled list of months. How can I keep these from doubling.

It worked after I tried it again..thanks for the help!

"Edwin Tam" wrote:

> Add the ".clear" after the first line.
>
> With cmbMonth
> .Clear
> .Additem "Jan"
> ....
>
>
> Regards,
> Edwin Tam
> [email protected]
> http://www.vonixx.com
>
>
> "juliejg1" wrote:
>
> > I have created a form containing a combo box using the following code:
> > With cmbMonth
> > .AddItem "Jan"
> > .AddItem "Feb"
> > .AddItem "Mar"
> > .AddItem "Apr"
> > .AddItem "May"
> > .AddItem "June"
> > .AddItem "July"
> > .AddItem "Aug"
> > .AddItem "Sept"
> > .AddItem "Oct"
> > .AddItem "Nov"
> > .AddItem "Dec"
> >
> > It works great except once an entry is made, the contents in the form fields
> > cleared, and another entry is to be made, the combo multiplies showing a
> > doubled list of months. How can I keep these from doubling.