I am trying to update an Access 2000 table using Visual Basic 20005 Express edition. I have managed to work out how to do it all except that the actual table does not get physically updated until the application ends/closes. I want to be able to update the table as soon as the sub form closes.

If more information is needed please ask. It has taken me weeks to get this far and I would hate to think this is a foible of vb.

Thanks.

David