Combo Box Order

I have about 9 records in a table. This is used as a combo box in a
number of tables. I want the data in the combo box to be in a
specific order; the first three records should be at the top then it
doesn't matter how the other reocrds appear.

Does anyone have any idea how this can be achieved?

Thanks so much,
Leee

On Fri, 16 Jan 2004 02:48:29 GMT, Leee <leee_smith@earthlink.net> wrote:
[color=blue]
>I have about 9 records in a table. This is used as a combo box in a
>number of tables. I want the data in the combo box to be in a
>specific order; the first three records should be at the top then it
>doesn't matter how the other reocrds appear.
>
>Does anyone have any idea how this can be achieved?
>
>Thanks so much,
>Leee[/color]

Access has no idea what "first 3" means since records do not have any
intrinsic, defined order. If there's something identifiable about the data in
those records, you can certainly use that to sort them.

add a field to your table called sortOrder, and number 1 - n in the
order you want to see in the combobox

create a query that gives you the combo box fields, ordered by
sortOrder

use the query as the source to your comboxBox

Leee <leee_smith@earthlink.net> wrote in message news:<33ke001t1qbk7qv2cemnpupdl5amb89h80@4ax.com>. ..[color=blue]
> I have about 9 records in a table. This is used as a combo box in a
> number of tables. I want the data in the combo box to be in a
> specific order; the first three records should be at the top then it
> doesn't matter how the other reocrds appear.
>
> Does anyone have any idea how this can be achieved?
>
> Thanks so much,
> Leee[/color]

Thanks, that sorted my problem. Appreciate the help!

On 16 Jan 2004 04:51:46 -0800, lesperancer@natpro.com (Roger) wrote:
[color=blue]
>add a field to your table called sortOrder, and number 1 - n in the
>order you want to see in the combobox
>
>create a query that gives you the combo box fields, ordered by
>sortOrder
>
>use the query as the source to your comboxBox
>
>Leee <leee_smith@earthlink.net> wrote in message news:<33ke001t1qbk7qv2cemnpupdl5amb89h80@4ax.com>. ..[color=green]
>> I have about 9 records in a table. This is used as a combo box in a
>> number of tables. I want the data in the combo box to be in a
>> specific order; the first three records should be at the top then it
>> doesn't matter how the other reocrds appear.
>>
>> Does anyone have any idea how this can be achieved?
>>
>> Thanks so much,
>> Leee[/color][/color]