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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only