Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Is it possible to sort records on a form by value in combo box?

Posted on 2011-05-06
5
Medium Priority
?
264 Views
Last Modified: 2012-05-11
I have a form with a record source as a table.  One of the controls on the form is a combo box whose record sorce is a different table.  I want the form to sort in the order of column 2 in the combo box.  Is this possible?
0
Comment
Question by:SueJStevens
  • 3
5 Comments
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 1000 total points
ID: 35707581
No.

You would need to make that column available in the form's recordsource (by selecting the field explicitly)  and you can then sort on it.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 1000 total points
ID: 35707629
Is the sort order of this combobox constantly/dynamically changing?

You can set the rowsource of the form to sort any field you want
0
 

Author Comment

by:SueJStevens
ID: 35707774
boag2000:
it is not the combo box that needs to be sorted--it isn't changing and it it is a straight forward sort.  The combo box displays the name of companies.  The fields in the combo box are CoID, CoName, etc.  The available fields in the form's datasource include CoID but do not include CoName as that exists in a different table.  We want to sort the data on the form by CoName.

Peter57r:
The reason we have not included that column as part of the form's record sorce is because we need to be able to update the records in the table which isn't possible with a query containing a join.

Peter57R & Boag2000:  Any recommendations on what to do from here?
0
 

Accepted Solution

by:
SueJStevens earned 0 total points
ID: 35708139
Got it!  We ended up creating a view in SQL Server with Check Option so that the view is updatable but also contains the column for the company name from the 2nd table.  We then do not make that column visible to users but it can be used as a sort criteria on the form.  Thanks for allowing me to post this question as I worked through our options.

Question:  Is there a way to assign points to the responders of this question even though I utilmately arrived at the solution on my own?
0
 

Author Closing Comment

by:SueJStevens
ID: 35735914
arrived at solution on my own but want to give the community credit for helping.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Implementing simple internal controls in the Microsoft Access application.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question