Again I don't understand.
In List1 you have Q11A what you want the LOCATE to be?
>sorry,
>i mean if thisform.list1.value have Q11,Q11A,Q2,Q2B,
>and flag1 have q1,q1a,q11a,q2b...etc characters type from dnc.dbf,
>thanks.
>
>
>>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.