VB One Table, Split 2 Subforms, Update Record 1

[rvermin]

Who can tell me the answer to following problem.

I have one Table called 2products". I splitted the data entry into two subforms.

Now, when I add a new record, and change from subform1 to subform 2, the record is not added yet in subform2. If I close the database and reopen it, it does know the new record. I would like to have the record when I change forms.

How can I solve this problem?

Many thanks,

Ramon

 

[arebelli]

after you have updated the first subform, you have to requery the second subform.
In the event afterupdate of the first you have to put this code

Private Sub Form_AfterUpdate()
Parent.SecondSubFormName.Requeryì
End Sub


You must replace "SecondSubFormName" with the nema of te second subform