三个单选按钮组的值分别为1(已出售),2(未出售),3(全部),所以查询按键 应用分支查询命令进行记录的筛选显示,如:
do case
case thisform.OptionGroup1.value=1
select...
case thisform.OptionGroup1.value=2
select...
case thisform.OptionGroup1.value=3
select....
endcase
select yourtablename
do case
case thisform.OptionGroup1.value=1
set filter to 出售信息="已出售"
go top
case thisform.OptionGroup1.value=2
set filter to 出售信息="未出售"
go top
case thisform.OptionGroup1.value=3
set filter to
go top
endcase
thisform.refresh