Access 2010 web DB: combo box basic problem

[Toby Honest]

Hello,

I am working on a simple Access 2010 web database, purpose: task administration for a few of the departments in my company. Tables: Tasks and Departments

Both tables are properly setup, with a lookup for DepartmentName in the Tasks table. I have already made a Task datasheet containing a query for showing the fields of the two tables just the way I want them to show. I am not quite happy with the datasheet form though, I would like to have some more possibilities regarding conditional formatting etc. I decided to build a multiple form with a similar query as the one in the datasheet, which I have done.

The challenge: I would very much like to sort the Tasks based on the DepartmentName field, with a combo box on top of the form. I have come so far that I have inserted and populated the combo box with a 'SELECT DEPARTMENTNAME FROM Tasks' query, and I have selected a row source. I just don't know what to do from here.How do I make the combo box fire the sort event?

Since this is a web database, there are no control wizards, leaving me clueless. Should I write code somewhere, or just a query? Please help me, I have googled, searched the MS resources, and browsed this forum in my opinion quite thoroughly, without finding the "combo box for complete dummies" recipe which I apparently need.

Kindest regards,
TEL

 

[SpentGeezer]

The challenge: I would very much like to sort the Tasks based on the DepartmentName field, with a combo box on top of the form. I have come so far that I have inserted and populated the combo box with a 'SELECT DEPARTMENTNAME FROM Tasks' query, and I have selected a row source. I just don't know what to do from here.How do I make the combo box fire the sort event?

Just order and group your query that is populating the combo (instead of just selecting all). Something like this:

SELECT Tasks.DEPARTMENTNAME
FROM Tasks
GROUP BY Tasks.DEPARTMENTNAME
ORDER BY Tasks.DEPARTMENTNAME;