Hi,

(1) I have noticed that with VB 5.0 if you have two tables related one to many, (for example an Invoice table with and Invoice Details table, related on InvNo), and you try to enter only one detail in a dbDataGrid, the recordset never gets saved unless you press the down arrow key. In other words the Update event and the BeforeUpdate event never get triggered if the user does not press on the down arrow key. This could be confusing to the user since he/she thinks the data was saved since they inputed a complete detail within the grid. How can I trigger an Update to force the save?

(2) Also in the same situation above how can I prevent the user from entering a second detail if and only if the first detail's total amount equals 0. I do not want the user entering a second detail unless the first one was completely entered?

Thank you in advance