Ok, this is a noob question.... I have a table with two fields ColorID and CName. I'm listing the names (CName) in a drop down box and I want them to show up alphabetically. They're currently showing up numerically by ColorID. I know this is incredibly simple to do but I seem to have forgotten how.