Order of items in Combo Box from Table

[Jeanie]

I know there are many questions out here about ordering the items in a list box and/or combo box...I'm just not clear on what I need to do.

I have a table that has three columns: Answer, Numeric Value, and Type. For each "Type" there are 2-10 different "answers". The "answers" in each type are assigned numbers from 1 to 10. For example:
Type - Y/N/D
Answer - Yes has number 1 assigned
Answer - No has number 2 assigned
Answer - Don't Know has number 3 assigned

When the table was set up they were entered in number order per type. Because of the way the table is set up, there is no primary key.

Most of the combo boxes come up in number order, however, there are a handful that do not. In reading through many discussions on this there was mention of a RecordSource - I'm guessing that is on a list box and not a combo box because I don't see it. I'm hoping that there is a simple fix...many of the responses talked about writing code...I'm a pretty "simple" ACCESS user with a a very basic understanding of the program and have never written code.

Any help would be appreciated.

Thanks,

Jeanie

 

[MarieMetcalf]

If I understand your question correctly you will want to
Create a query selecting the data you want to show in the combo box. In your query you can sort your data in the order that you want.
Then look at the properties of your combo box: on the 'data'tab You will find 'ROW SOURCE TYPE' - choose query,
for 'ROW SOURCE' select the query you have created.
Now your data in the combo box will be in order and if you add additional data to the table it will automatically show up.