Hi,

I've created a database in Access 2007 and connected it to Visual Basic 2008.

My database have tables Coachee and Coach. Details of Coachee are displayed in one form and there's a button that when clicked will show details of the Coach of that particular Coachee in a another form.

If the Coach is not in database, user will be prompt to insert a new Coach record. Problem is, when saved, the newly inserted record will not be displayed and i have to exit and rerun the program, only then the record will be displayed.

How can I display the newly inserted records without exiting?