Add records in the subform

[le888]

Hi everyone,

My problem is :

I have a form and a subform in which I can add new relationships with other companies. I explain, say, Company A is related to Company B, C. The form that I have created, I can add new relationships to Company A , say, related to D and E. The problem is that I just want to view the relationships that I have add in the current form, that are the relationship with D and E. I want to hide all the relationships which existe already ( relationship B and C). Is it possible ? I have created a add new record in the subform, it doesn't give the result that I want. When I add new records in the subform, I see all the records that I have just add but when I skipp to "the second page" of the form and return to the first page, all my records that I have just add was gone. So, any ideas will be appreciated.

Thanks,

Le

 

[le888]

Where should I put this code?

Le

 

[le888]

I don't think I have an update data. Any ideas?

Thanks.

 

[le888]

I have put in my query that you have suggest but a popup form ask me the " LastUpdateDt" parametre?

Le

 

[le888]

Thanks again,

Le