Sort by month

[Symlink]

I have a table with product numbers and their cost. That table has 3 fields : SKU, Cost, Month. (The cost can change every month, therefore the list is built to have a cost / month)



I want the user to be able to input the data in the table using the form but I would like the form to be sorted Alphanumerically for the SKU numbers and then per month (in their normal order not alphanumerically).

I have a combobox (named month for testing purposes) to force the user to select one of the 12 months and the field type is Text.

Also I am unsure how to "autosort" (or apply a permanent sort) the form whenever it's opened. Will it be applied if I just set the sort and then restrict the user from seeing let's see design mode?

Thanks for the help.

[June7]

The Month field is text and this has month names, not numbers? Need to translate the name to number. Here is one way:

Month([Month] & "/1/2000")

Use a query with SORT BY clause as form RecordSource.

BTW, should not use reserved words as names. Month is a reserved word.

[Symlink]

I tried adding a button to MsgBox(Month([Month] & "/1/2000")) and it gives me an error. I am reading the syntax of the Month() function (here : http://www.techonthenet.com/access/f...date/month.php ) and what I can read is you can only provide the Month() function with a valid numerical date ? Or maybe I missed something. And thanks for the tip about the reserved name

[Symlink]

Alright sorry for that I got it working. I will work on the Query RecordSource for the form. Thanks alot for your time, it is really appreciated

[June7]

I tested the expression before I suggested as it was the first time I thought of it. Glad you got it working.