Refresh Forms problem

[livvie]

I have a Main Form with 2 tabs. One of the tabs has a datasheet form that lists all record. The other has the details of the record depending on what is selected in the list. My problem is that when I add a new record I cannot see it on the details tab until I close the app and reload. It is on the list tab alright. I have tried requery everywhere. i am getting desperate at this stage. Any help please!! I am using Access Project

 

[Oldsoftboss]

You need to add the line to an after update event on your form:

Me.subformname.requery

Dave

 

[livvie]

I've added in so many places at this stage but this doesn't work either. Sorry anything else.

You need to add the line to an after update event on your form:

Me.subformname.requery

Dave