主题：表事件 currentchanged报错

If forms("日新车队").opened Then
    Dim r As Row = e.Table.Current
    If r IsNot Nothing Then
        If r("二保日期") >= Date.Today AndAlso r("营运证年审") >= Date.Today AndAlso r("靠挂费日期") >= Date.Today Then
            forms("日新车队").Controls("TextBox23").Text = "正常"
        Else     If r("二保日期") < Date.Today AndAlso r("营运证年审") >= Date.Today AndAlso r("靠挂费日期") >= Date.Today Then
            forms("日新车队").Controls("TextBox23").Text = "漏保"
        Else If r("二保日期") < Date.Today AndAlso r("营运证年审") < Date.Today AndAlso r("靠挂费日期") >= Date.Today Then
            forms("日新车队").Controls("TextBox23").Text = "漏保|漏审"
        Else
            forms("日新车队").Controls("TextBox23").Text = "漏保|漏审|漏费"
        End If
    Else
        forms("日新车队").Controls("TextBox23").Text = Nothing
    End If
End If

If forms("日新车队").opened Then
    Dim r As Row = e.Table.Current
    If r IsNot Nothing Then
        If r("二保日期") >= Date.Today AndAlso r("营运证年审") >= Date.Today AndAlso r("靠挂费日期") >= Date.Today Then
            forms("日新车队").Controls("TextBox23").Text = "正常"
        Else If r("二保日期") < Date.Today AndAlso r("营运证年审") >= Date.Today AndAlso r("靠挂费日期") >= Date.Today Then
            forms("日新车队").Controls("TextBox23").Text = "漏保"
        Else If r("二保日期") < Date.Today AndAlso r("营运证年审") < Date.Today AndAlso r("靠挂费日期") >= Date.Today Then
            forms("日新车队").Controls("TextBox23").Text = "漏保|漏审"
        Else If r("二保日期") >= Date.Today AndAlso r("营运证年审") < Date.Today AndAlso r("靠挂费日期") < Date.Today Then
            forms("日新车队").Controls("TextBox23").Text = "漏审|漏费"
        Else If r("二保日期") >= Date.Today AndAlso r("营运证年审") < Date.Today AndAlso r("靠挂费日期") >= Date.Today Then
            forms("日新车队").Controls("TextBox23").Text = "漏审"
        Else If r("二保日期") >= Date.Today AndAlso r("营运证年审") >= Date.Today AndAlso r("靠挂费日期") < Date.Today Then
            forms("日新车队").Controls("TextBox23").Text = "漏费"
        Else If r("二保日期") < Date.Today AndAlso r("营运证年审") >= Date.Today AndAlso r("靠挂费日期") < Date.Today Then
            forms("日新车队").Controls("TextBox23").Text = "漏保|漏费"
        Else
            forms("日新车队").Controls("TextBox23").Text = "漏保|漏审|漏费"
        End If
        Forms("日新车队").Controls("TextBox22").text = DataTables("日新车队").Compute("count(二保日期)", "二保日期 < #" & Date.Today & "#")
        Forms("日新车队").Controls("TextBox21").text = DataTables("日新车队").Compute("count(二保日期)", "二保日期 >= #" & Date.Today & "#")
        Forms("日新车队").Controls("TextBox20").text = DataTables("日新车队").Compute("count(车号)")
       
    Else
        forms("日新车队").Controls("TextBox23").Text = Nothing
        Forms("日新车队").Controls("TextBox22").text = Nothing
        Forms("日新车队").Controls("TextBox21").text = Nothing
        Forms("日新车队").Controls("TextBox20").text = Nothing
    End If
End If

 

  例子发上来。

  报错是因为你电脑日期格式设置错了，要设置成短日期，不要带有星期几那种

 

http://jingyan.baidu.com/article/fcb5aff789824fedaa4a712e.html

 

 

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:日新车队管理系统.foxdb

 回复9楼，我测试，状态会变动啊。

 呃....汗，那你就看我怎么写代码的？代码写在AfterFilter那里。