3
Contributors
3
Replies
5
Views
8 Years
Discussion Span
Last Post by binoj_daniel
0

I am new in VB & I am having problem in Filter ( See Form2). My another problem is my boss want to see all Follow Up Report (Call Report of the Customer; Form6). Generally he want to see current FollowUp but he want when needed he can see each Follow Up Report.
I have given code for this but it show error. Please help. (Form6)


Adodc1.RecordSource = "select * from Table2"
Adodc1.Recordset("FOLLOW_UP_DATE") = DTPicker1.Value
Adodc1.Recordset("CURRENT_FOLLOW_UP") = Text1.Text
Adodc1.Recordset("NEXT_FOLLOW_UP_DATE") = DTPicker2.Value
Adodc1.Recordset.Update

Adodc1.RecordSource = "select * from Follow_Up"

If Adodc1.Recordset("1st_Follow_Up_Date") = Null Then
Adodc1.Recordset("1st_Follow_Up_Date") = DTPicker1.Value
Adodc1.Recordset.Update
End If

If Not Adodc1.Recordset("1st_Follow_Up_Date") = "" Then
Adodc1.Recordset("2nd_Follow_Up_Date") = DTPicker1.Value
End If

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.