hecash,
Yes, I saw that. I'm not dealing with mySQL, so it is not the answer. I think the stored procedure is the answer, but I have to wait until tomorrow to try it out. If nothing else, close the current form, update the table(s), then reopen the form.
Chris