Set focus

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.
I would like it to go to the current month and year. I have tried turning
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10192-set-focus.html
this field into a Date field and have not been sucessful. I hope you can
still help.
Thanks
Chey

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10192

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10192
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.
> 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

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
> > 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10192