>I loaded your code in VB 6.0, but it does not recognize several lines. I couldn't run the code.
Did you save the lines that I have sent in a .frm file and the open it in VB.
>I was reading SQL reference book over the weekend. It says that only one table can be updated at time. I don't know if that is the problem.
So why was I able?
Is it an Access database, if so send me a small database with a small portion of your (only what is needed to reproduce the error) and I will check it.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com