I have a table that will always contain only one record. I am trying to create a form that will display the record and allow the user to make changes to the record.

One of the fields is a character field that contains the name of a month (JANUARY, FEBRUARY, etc.).

I thought I would try and use a combo box but I can't figure this out. When the form is displayed, I want it to display the current value of the field. And I want the the user to be able to select the month from a list instead of typing it in. I can get the combo box to display the current record by setting the rowtype of the combobox to 6 - fields, but then it doesn't contain the names of the other months. I can get it to display the names of all the months by setting the rowtype to 1 - value, but then it doesn't display the value of the current record.

Any ideas?

Thanks!


Jeff Rusch
UW-Madison