Rss & SiteMap

Foxtable(狐表) http://www.foxtable.com

新一代数据库软件,完美融合Access、Foxpro、Excel、vb.net之优势,人人都能掌握的快速软件开发工具!
共3 条记录, 每页显示 10 条, 页签: [1]
[浏览完整版]

标题:关联表的筛选窗口设计

1楼
woodiy 发表于:2009/3/9 12:13:00

图片点击可在新窗口打开查看此主题相关图片如下:无标题.jpg
图片点击可在新窗口打开查看

我筛选控件的代码如下:Dim Filter As String
With e.Form.Controls("TextBox1")
    If .Value IsNot Nothing Then
        Filter = "[色名色号] LIKE '*" & .Value & "*'"
    End If
End With
With e.Form.Controls("TextBox2")
    If .Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " and "
        End If
        Filter = Filter & "[款号] LIKE '*" & .Value & "*'"
    End If
End With
With e.Form.Controls("TextBox3")
    If .Value IsNot Nothing Then
        If Filter >"" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "[缸号] LIKE '*" & .Value & "*'"
    End If
End With
If Filter > "" Then
    Tables("生产管理").Filter = Filter
End If

为什么代码没有起作用,说明一下。谢谢!
2楼
kylin 发表于:2009/3/9 12:25:00
Tables("生产管理").Filter = Filter
应该用
Tables("父表名.子表名").Filter = Filter
3楼
woodiy 发表于:2009/3/9 12:28:00
好的,谢谢!
共3 条记录, 每页显示 10 条, 页签: [1]

Copyright © 2000 - 2018 foxtable.com Tel: 4000-810-820 粤ICP备11091905号

Powered By Dvbbs Version 8.3.0
Processed in .03125 s, 2 queries.