Could anyone else offer a bit more input here please? I've tried some of the initial steps recommended, but still having a bit of a hard time grasping it all.
Do the rows I want to move need to become part of the Option Group?
When I put in the code
Code:
Me.combobox.RowSource = "SELECT fieldname FROM tablename ORDER BY fieldname " & IIf(Me.Option=0, "Ascending", "Descending") & ";"
it is giving me an error. I looked at the microsoft coding guides but I'm having a hard time with the correct form.
Thanks for any additional help.