Search results

Thanks! Where can I do that?

I don't know what changed, it just started listing that way one day recently. Yes, to answer your question, ProjectID is a number. Any suggestions would be greatly appreciated. Thanks.

Ok, I removed the "Union Select" from the code, and it did fix the sorting issue, but caused a different issue. There is a "Reset" button on the form, that upon click will reset all of these combo box drop downs to their default text which is "*". When I try to use the reset button now, it...

Honestly, I can't remember. I developed this many years ago, and I want to say that union clause was something I had to add to get the form to work correctly, but I can't remember now. I can try removing it, and see if that makes a difference. What would you suggest?

The rowsource has this: SELECT tblProject.ProjectID FROM tblProject UNION SELECT '*' FROM tblProject ORDER BY ProjectID The table (tblProject) has the field (ProjectID), which is the number I'm trying to list in the drop down on the form. There are several drop downs on the form, for various...

I do have the field classified as a number in the table. What can I change to help this situation? Thanks!

Thanks! How can I reset them? In the table? In the form?

Hello, I'm stumped. I have a drop down combo box in a form that lists projects by number, pulled from a project number field in the base table. It used to list the numbers in order, 1, 2, 3, etc., all of a sudden, it is now listing them like this: 1, 10, 100, 101, 102, 103, 104, 105, 106, 107...