Question on order

[dsomers]

I've got one more question. I have a form that adds and deletes apartment numbers. When I entered the data to start with I entered it in the datasheet view of the table and put in numbers like 1, 2, 3, ..., etc. My form allows for the addition and deletion of apartment numbers. When I delete apartment number 3, and then try to add it back, the combo box sticks it at the end of the list when I go to delete it again. The table I'm using for this is called tblApartmentInfo and it has three fields: ApartmentID, BuildingID and ApartmentNumber.

Is there a way that I can make the combo box order it the way it should be?

Thanks!
David Somers

 

[neileg]

Base the combo on a query and sort the query in the order you want.

 

[dsomers]

Yeah, I've done that. When I order it, it goes like 1, 11, 12, ..., 2, 20, ...., 3, 30..., etc. This I know is ordering, but not the ordering that I would like for it to do.

Is there a way to make it order, 1,2,3, ...., A, B, C, etc., because I have numbers and letters for apartment numbers.

Thanks!
David Somers

 

[dsomers]

I have one more question that doesn't pertain to this, but I figured I'd put it here so people don't complain about many topics.

I have a table that holds the a property name that I want to be displayed on the Switchboard. I'm not really sure of how to do that and I tried [Tables]![tblName]![Name] but that doesn't work. Is there a way to get that to show up on the switchboard in the label I've created?

Thanks!
David Somers

 

[neileg]

Sorting
This is a text field, and that's the way text fields sort, first on the first character, then on the second, and so on. If you want a different sort order, you have to create a separate field and put something in there.

Alternatively, use a decimal for your number and devise a way of deriving the A's and B's. For example you could hold 11 as 11.0, 11A as 11.1, 11B as 11.2 and so on. Then calculate the number display from the integer part and a lookup on the decimal part for the letter.

Switchboard
You're better off starting a new topic. People won't complain.
I don't like messing with the Access switchboard.
If you are holding property names in a table, how does Access know which name you want to be displayed? You're going to need to use either code or a query to produce a single field to populate your text box.