you cannot get MySQL to update in such a manner, however you can get a VB/VBA program to do this by user a form timer.

as I read it
your form is not refreshing with new data
so its going to be either
you are not requesting the data
you are getting the data but doing nothing with it
you are trying to uopdate the form but because of the design its not doign that.

so that could be somethign to do with your recordset type.
it could be something as simple as issuing a me.recordset.refresh command


persoanlly Im not going to wade through a whole pile of VB to find what the culprit is. in my books you need to do more to identify why what you expect to happen doesn't
thats going to involve putting break/watchpoints on your code then stepping through each but to find out if what you expect to happen does. having done that (and hopefully indentified where the problem lies) by all mean come back