Ok, I have looked all over UA and can't seem to find what I'm looking for? So either what I'm doing is so simple that no one needs to ask?? Well anyway, I have a form and a subform. I make my selection in my combo box on the main form which brings up my selections on my subform. Example.

Main Form
Combo box = Set

Sub Form
Number and Name are dispalyed depending on the different Set

Now what I want to do is add as option box, which I have done, and have Alphabetically and Numerically so that I can sort. I have no idea what I need to do here?? Any help would be greatly appreciated.

What is the option box for and what is it that you want to be alphabeticaly and numerically sorted? Can you be more clearer in your question and possibly post an example of the db that you are creating?

Ok..... I have a form. On the FORM I have a combo box = "Set". When you choose a specific "Set", on the SUBFORM you get your results. In example:

Number/ Name/ Set/

Now what I want to do, is when the results come up, click the option group box to sort them A-Z or 1-3? I hope that's a little clearer, it not I can post my db? Thank you.