Rank / move combo box with adjacent arrow button

[Heezea]

Hey guys, I've done several google searches and forum searches, but I can't find any question similar to mine though I'm sure it's been asked before.

My question is:
How do you add buttons (up/down arrows) that are tied to combo boxes and would make the combo box move up or down, thereby changing the order of the item in the combo box.

As an example:


Before
1 Dogs (arrow up) (arrow down)
2 Cats (arrow up) (arrow down)

*Press arrow up for cats*
After:
1 Cats (arrow up) (arrow down)
2 Dogs (arrow up) (arrow down)

[June7]

This is changing the Order By clause of the RowSource.

Put up/down toggle or radio buttons in an Option Group control.

Then in the AfterUpdate event of Option Group control, something like:

Me.combobox.RowSource = "SELECT fieldname FROM tablename ORDER BY fieldname " & IIf(Me.Option=0, "Ascending", "Descending") & ";"

[Heezea]

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

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.

[June7]

Nothing wrong with the syntax. I seem to have misunderstood your request. What I suggested only switches the sort order of the list between ascending and descending. Moving a single item would be far more complicated. Why would you want to?

Use your combobox name and your fieldname and your option group name. I don't know those so I just used a generic "combobox" and "fieldname" and "Option".

Do you know how to build an Option Group control?