Hello.

I'm creating a project using Microsoft Access 2007 & Visual Basic 2008.
I have two tables in my database, Staff and Training Attended. The Training Attended records of Staff are displayed in datagridview, residing in a different form from the Staff details.

What my program does is, it will display all of the Staff's list of Training Attended in datagridview once I click the button in Staff form. I've succeeded in retrieving the records. using
Code:
bindingsource.filter
The problem is that I can't insert/update/delete records in the Training Attended datagridview. it keep giving me this error:
Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

How can i solve my problem?? is there any way to do this using table adapter, bindingsource or something without using Ole.DB or SQL??

Your help is very much appreciated. thanks!