Link to home
Start Free TrialLog in
Avatar of smods
smods

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of smods
smods

ASKER

Excellent! Cheers for that capricorn1

Is there also a way to sort the combo box data in descending order?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial