Date Box - A couple of things

Hi all,

Please see the attached database.  Jez created the form frm_KPI_Main.

As you can see the MonthID is a text field and the order field is used to sort them into the correct order.  I am going to be adding some buttons to launch some reports directly from this form and I want to use the Month ID as the search criteria in the query.  

However the date combo box doesn't return what is selected (i.e. December 2010) but it returns the order (01) - Is there a way around this?

Also is it possible to arrange the dates into descending order?

Regards

Chris
Copy-of-ee5.mdb
smodsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
you can extract the date column from the listbox by using

Me.[Order].Column(0)
0
 
smodsAuthor Commented:
Excellent! Cheers for that capricorn1

Is there also a way to sort the combo box data in descending order?
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
just set the order by clause to Desc in the rowsource of the list box

select monthid,[order] from tableName order by [order] desc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.