How to Display Records in a SubForm in Combo Box Sequence (1 Viewer)

[JGravesNBS]

I have the following SubForm Continuous form with CategoryDescID Combo Box that allows me to add, change & delete records

SubForm displays in the following sequence:
CategoryCodeID
1 Road Saw
2 Blacktop Roller
3 Angle Dozer

How can I sort the SubForm to display as follows:
CategoryCodeID
3 Angle Dozer
2 Blacktop Roller
1 Road Saw

Category Code & Description Table
CategoryCodeID CategoryDesc
1 Road Saw
2 Blacktop Roller
3 Angle Dozer

 

[James Deckert]

go into design view for your combobox. Edit the query that is the row source for the combobox, and sort based on the field you want sorted by.

 

[JGravesNBS]

Thanks for your response

My combo box is sorted OK


If I create 3 records by selecting input from the combo box they display in the continuous subform as follows:
CategoryCodeID

1 Road Saw
2 Blacktop Roller
3 Angle Dozer

How can I sort the SubForm detail record to display as follows:
CategoryCodeID

3 Angle Dozer
2 Blacktop Roller
1 Road Saw

 

[James Deckert]

Sorry, I thought you were saying that the combobox wasn't sorted.
What is the RecordSource for the subform? This is where you'll need to do the sort