Set focus

#1 (**permalink**) 28-Jul-2006, 08:10 AM

Hello,
I have a combo box with a list of the month and year in it. This is a text
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10192-set-focus.html
field. So I don't know if this will work.
I would like it to go to the current month and year. I have tried turning
this field into a Date field and have not been sucessful. I hope you can
still help.
Thanks
Chey

*

#2 (**permalink**) 28-Jul-2006, 08:10 AM

Hi

There are many way to do this

You can either add a second column to the combo and next to each month put
the number - Jan = 1, Feb = 2, Mar = 3, etc. Then sort the combo by this

Or

Create the combo from a date field and set the combo's format to mmmm yyyy

Or

Create a table called month add an ID field (auto number) and then insert
the months in order Jan, Feb, Mar etc. Then base your combo on this

Ect,

Etc

You need to have the combo

--
Wayne

"Chey" wrote:

> Hello,
> I have a combo box with a list of the month and year in it. This is a text
> field. So I don't know if this will work.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10192
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10192
> I would like it to go to the current month and year. I have tried turning
> this field into a Date field and have not been sucessful. I hope you can
> still help.
> Thanks
> Chey

#3 (**permalink**) 28-Jul-2006, 08:10 AM

Okay I don't know how I should ask this part so I will try by best.
When I choose my month and year, it filters my form. Which method below
would still allow me to filter my form properly?

"Wayne-I-M" wrote:

> Hi
>
> There are many way to do this
>
> You can either add a second column to the combo and next to each month put
> the number - Jan = 1, Feb = 2, Mar = 3, etc. Then sort the combo by this
>
> Or
>
> Create the combo from a date field and set the combo's format to mmmm yyyy
>
> Or
>
> Create a table called month add an ID field (auto number) and then insert
> the months in order Jan, Feb, Mar etc. Then base your combo on this
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10192
>
> Ect,
>
> Etc
>
>
> You need to have the combo
>
> --
> Wayne
>
>
>
>
> "Chey" wrote:
>
> > Hello,
> > I have a combo box with a list of the month and year in it. This is a text
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10192
> > field. So I don't know if this will work.
> > I would like it to go to the current month and year. I have tried turning
> > this field into a Date field and have not been sucessful. I hope you can
> > still help.
> > Thanks
> > Chey