Sorting records from a single-record form?

[Ally1205]

I have a main (single record) form which takes its data from a query running off my main Client-records table.



I would like to configure the form so that I can sort the records based on certain fields, such as County. I would like, say, a combo box which shows all counties in its drop-down list. If I click on one of the counties, the record showing in my form would be the first client who lives in that county. If I then click the next record button, the next resident of that county would show, and so on.

This would be much easier, for my purposes, than, say, having a separate form for each county, each running on a county-specific query.

Can this be done easily. If not, can anyone suggest the easiest way to achieve something similar?

I want to view each record in a single-record form, because there are so many fields I need to examine. It would be too awkward to simply sort the main table by the county field. Reading all of the fields would be awkward, because of the extensive width of the table.

Many thanks for any suggestions,
Ally1205

[amrut]

Use an unbound combo box having the counties in its dropdown list in form header and filter the form in afterupdate event of this combo box.
For multiple fields, you will need to build the filter criteria.
See here for an example - http://www.techonthenet.com/access/f...ilter_form.php

[Ally1205]

amrut,
Thank you. That was too easy!