Hello, Buddy
Ya, you are right for when any record or data add in table then automatically alert to we.
But that is not possible bcoz Database work only that store data safely and give our information in requirement in our query.
If you want to detect new record when add in table,
For that you need to reload your table contains through query.
second thing your project was going to hang bcoz you not manage your Forms and Functions in perfect format.
Create one function for getdata from your table
Public funtion GetData()
That function call when you need data of table
For reload your data Create one timer that already you created, But give some timing for hold.
Ex. every five minute or one minite holding timeter
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Timer1.Enabled = True
Timer1.Interval = 3000
End Sub
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
MessageBox.Show("This messagebox will popup every 3 seconds!", "www.interloper.nl", MessageBoxButtons.OK, MessageBoxIcon.Information)
End Sub
End Class
If any confusing, comment on my answer.
Please improve your coding with divide coding in different function or classes.
For that don't loading on system.
Happy Coding buddy :)