Did George say why to use Insert-SQL instead of APPEND BLANK?
TIA
>>>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