Displaying newly added records without exiting & rerun project.

[vijy]

i have two tables in Access:

coachee(coacheeID,name,position,coachID) -i only listed a few fields to simplify it
coach(coachID,name,position)

in VB, form Coachee displays coachee details and coach details are retrieved by clicking Coach Details button on the coachee form

i'm using coachbindingsource.filter to retrieve and display coach's details.

you have to use begintransaction while inserting records in access.
can you show me the code using to insert records?