Ascending Combobox pulling from table field

[Charles G via AccessMonster.com]

I have a form that shoots data into a query. However, I have a combobox on my
form that gets its values from tblCPFTellers. The table field name is
[BNumber] and is a text field that houses info such as (B34346, B12345, etc)

My Form combobox for the B# field has the Row Source:
SELECT DISTINCT [BNumber] FROM [tblCPFTellers];

Form Info:
Order By: qryTellerAwardForm.BNumber

qryTellerAwardForm has the B# field sorted ascending. At first, all the B #'s
were listed in ascending order, which is what I want. Since then, however,
I've added four new tellers and 4 new B#'s and I can't get these in order.

I want to pull this information from tblCPFTellers and not qryTellerAwardForm.
How can I get my B# combobox to list the values in ascending order?

-Charles-

 

[Douglas J. Steele]

Sounds as though you're using the table as the RowSource for the combobox.
Create a query that sorts the data in the desired order, and use the query
as the RowSource instead.

 

[Charles G via AccessMonster.com]

Create a query that sorts the data in the desired order, and use the query

as the RowSource instead.

I thought maybe I could get around creating another query, but I used the
above method and all is good. Thanks.

-Charles-