I used autonumber for my id. i attach the screen shot..
and i dont know how to make a code for compute command..
It should compute all the payments on that day, but i really dont have an idea how to make it.. ill attach my vb and access so you can guys take a look..
Access And VB.zip
thanks guys :D