>>>I have option group with days of week (only Monday through Friday). I have nDow in my table. How can I bind this optiongroup to my field's value, if nDow for Monday is 2?
>>>
>>>Thanks in advance.
AFAIK it can't be done. The trick you described below is the best I can think of in this case.
>>
>>Look at
DOW(datefield, 2)
>
>Not sure how does this help me. I guess, I didn't explain my need very well. I have a numeric field in a table called nDow. I want to show options with days of weeks
>Monday Tuesday ... Friday and have my field to be a controlsource for the option group. Borislav and me both have the same idea of adding invisible Sunday to the option group. This way the second available and visible option Monday will be saved as 2 in my table (exactly what I want, since a week starts with Sunday).
Lennert