I'm having a hard time understanding what you're asking, can you elaborate some more?

Assuming you're asking something like I have Store A with a rank 6 and Store B with a rank 3, then I want to sort queries based on the value there? Does this combobox have a control source or did you type in the values when you made the combo box? If I'm understanding correctly, I think you'd get some use from Relational Combo

Example:  Table tblOffice used as Combo.  Two fields Title and Rank.  Another table tblland has combo box field that pulls Tile and shows rank.  Instead of adding the number in Ranking field  is there a way to automatically bring Rank data into Ranking Field?

See Evil Access Stuff. Lookup values inside the tables are not fun. I would suggest changing it to that relational combo video I sent.

But you should be able to do HName.Column(2) to get the number value from that.

William
If what I'm understanding is you don't want your combo box sorted alphabetically by OfficeTitle you want it sorted by Rank, I believe that the Custom Sort Order video fits right in with your needs.

If you don't need / want to see the rank in your combo just make it's width 0 (zero).  It will still be there to order the choices in the Combo Box.

I just noticed the second part of your question - is there a way to automatically bring Rank data into Ranking Field?

First yes there is a way.  See Adam's response.
Second, I don't recommend storing that in multiple tables. (What if your sort order changes?)

To clarify:
To store a second value that is in the combo box using your picture 1 example, you would need to set the default value property of Ranking to the third column of your combo box HName.
Remember that Combo Boxes are zero based.  So ID is 0, OfficeTitle is 1, and Rank is 2

Ranking default value  = HName.Column(2)
-------

The better way would be to use the custom sort in a query for ordering your records.  You could use DLookup to figure out the sort order but that has the potential to slow down your database greatly depending how many records you have.