Looking further at this, is it possible to have more than one checkbox checked? If so, by setting got_a_bite=1 and then testing IF got_a_bite will cause this problem.
>>* -- start code
>>m_filter = ""
>>got_a_bite = .f.
>>
>>if thisform.chk_one.value = 1
>> m_filter = "myfld = '1'"
>> got_a_bite = .t.
>>endif
>>
>>if thisform.chk_two.value = 1
>> if got_a_bite
>> m_filter = m_filter + " or "
>> endif
>> m_filter = m_filter + "myfld = '3'"
>> got_a_bite = 1
>>endif
>>
>>if thisform.chk_three.value = 1
>> if got_a_bite
>> m_filter = m_filter + " or "
>> endif
>> m_filter = m_filter + "myfld = '7'"
>> got_a_bite = 1
>>endif
>>?m_filter
>>* -- end of code
>>thanks
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement