>>Also, when I set the controlsource to a numeric it allows me to select any option... There is some trick that I forgot to use it on a character field...
>
>Each option caption should be an available choice. For instance, I'm currently working on the form, which uses three p-views. I have two option group and both work just fine. In both cases, it's a character field.

BTW, in another thread George Tasker advised me to use Insert-SQL for views, not APPEND BLANK.


>>>What is the data type of the control source. Is it logical, numeric, or character?
>>>
>>>You may need to "prep" the data after the append blank like this
>>>
>>>
>>>

>>>ThisForm.nTransId = -1
>>>REQUERY("MyView")
>>>append blank
>>>replace optiongroupfield with .f. or
>>>replace optiongroupfield with 0 or
>>>replace optiongroupfield with [YES]
>>>thisform.refresh()
>>>

>>>
>>>
>>>>I have a form that is based on a p-view. The textboxes controlsource is the field in the view. I have one optiongroup with two options. when I add a new record by:
>>>>

>>>>ThisForm.nTransId = -1
>>>>REQUERY("MyView")
>>>>APPEND BLANK IN MyView
>>>>ThisForm.Refresh
>>>>

>>>>
>>>>The optiongroup will only allow the first option to be selected...
>>>>
>>>>What am I missing?
>>>>
>>>>TIA