I have this code on a button on my subform which goes to the next Date, and based on that date, changes the information on 3 other subforms:

Private Sub GoNext_Click()
On Error GoTo Err_GoNext_Click


DoCmd.GoToRecord , , acNext
Screen.ActiveForm.Refresh

Exit_GoNext_Click:
Exit Sub

Err_GoNext_Click:
MsgBox Err.Description
Resume Exit_GoNext_Click

End Sub

I have the same subform on another form. The problem I have is, everytime both of my forms are open when I click the button to go to the next date, it refreshes the other subforms, but keeps staying in the first date. If I have only one form open, it works perfect and all the data moves accordingly. What is wrong with this. I am going crazy and can't figure this out. Please help!! Thanks in advance.