newbie needs combo box help

[dab1477]

Thanks in advance for the assist.

How do I get a drop down menu to show or bind to 2 columns?

I have a form that uses a drop down menu to allow the user
to choose from a listing of downtime reasons. The reasons
show up, but not in alpabetical order. In addition, I
added "Reason #" to the table and assigned EACH reason a #.

I.E. 1. Startup Scrap
2. Line Crash
3. Rolls Sticking.....etc.

I placed the Reason # in a separate field, such that the
table has 3 columns (key ID, Reason #, Reason Code).

Only the Reason Code column is stored in a Master table.
The idea being that I can recall downtime quantities by
reason.

I thought of revising the Reason Code from "Startup Scrap"
to "1. Startup Scrap", but I still can't get the Reason
Code drop down menu to show in alphanumeric order. It
shows in the primary key ID order. I see that I should
have sorted the list prior to importing. Lessons learned.
Now I need to alter. Thanks for the assist.

 

[Sandra Daigle]

Just base the rowsource on a query that sorts the data according to Reson
Code. For example, if your table is named 'MyReasons' your SQL might look
something like this:

Select [Reason #], [Reason Code] from MyReasons order by [Reason Code];

 

[Guest]

Thanks Sandra. I performed the query and bound it to the
combo box. Works fine.

-----Original Message-----
Just base the rowsource on a query that sorts the data according to Reson
Code. For example, if your table is named 'MyReasons' your SQL might look
something like this:

Select [Reason #], [Reason Code] from MyReasons order by [Reason Code];

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Thanks in advance for the assist.

How do I get a drop down menu to show or bind to 2 columns?

I have a form that uses a drop down menu to allow the user
to choose from a listing of downtime reasons. The reasons
show up, but not in alpabetical order. In addition, I
added "Reason #" to the table and assigned EACH reason a #.

I.E. 1. Startup Scrap
2. Line Crash
3. Rolls Sticking.....etc.

I placed the Reason # in a separate field, such that the
table has 3 columns (key ID, Reason #, Reason Code).

Only the Reason Code column is stored in a Master table.
The idea being that I can recall downtime quantities by
reason.

I thought of revising the Reason Code from "Startup Scrap"
to "1. Startup Scrap", but I still can't get the Reason
Code drop down menu to show in alphanumeric order. It
shows in the primary key ID order. I see that I should
have sorted the list prior to importing. Lessons learned.
Now I need to alter. Thanks for the assist.

.