Where?
If you have [Q11A] in thisform.text42.Value
lnFor = VAL(SUBSTR(thisform.text42.Value,2)) && this will be equal to 11
>hi,
>
>any idea if i have q11 and q11A(not the same flag1),
>
>LOCAL lnFor
>thisform.text42.Value = thisform.list1.value
>CLOSE all
>SELECT 0
>USE dnc
>lnFor = VAL(SUBSTR(thisform.text42.Value,2))
>LOCATE FOR flag1 = m.lnFor
>ThisForm.Label1.Caption = q1
>ThisForm.Label2.Caption = q11
>CLOSE all
>USE answers
>
>thanks.
>>
>>LOCAL lnFor
>>thisform.text42.Value = thisform.list1.value
>>CLOSE all
>>SELECT 0
>>USE dnc
>>lnFor = VAL(SUBSTR(thisform.text42.Value,2))
>>LOCATE FOR flag1 = m.lnFor
>>ThisForm.Label1.Caption = q1
>>ThisForm.Label2.Caption = q11
>>CLOSE all
>>USE answers
>>
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
