[AccessD] Month name in list box to number

Hi Chester

If you didn't have the option to modify the combo, the month value
could be found with this simple formula:

  intMonth = Month(strFullMonthName & "/1")

Please note the names of the months must be localized.

/gustav


> I have a form with a list box filled with month names. Ex January. I
> have a table that has data stored by month number. How can a convert the
> month name to a number to find the appropriate record in the table. I
> can do it with a select in code but thought there might be an easier way
> to query the table based on the selection from the form. Thanks

> No trees were killed in the sending of this message. However a large
> number of electrons were terribly inconvenienced.