refresh popup

[Ken Ivins]

I have a popup form linked to an open single record form (frmMainActive).
When I navigate to the next record I want the popup to refresh to the new
record.

Which property event would I write a refresh command for the popup. On
frmMainActive I tried "On Data Change" and on "On Data Set Change". Maybe it
is my code. I used:

Private Sub Form_DataSetChange()
Forms!frmBilling.Refresh

End Sub


Thanks,
Ken

 

[Wayne Morgan]

The form event that fires when you move from one record to another is the
Current event. You will probably need to Requery rather than Refresh. Does
the query feeding the popup refer to a value on the main form? If not, you
probably won't be able to have the popup follow the main form unless you
also tell the popup which record to go to.

 

[Ken Ivins]

Dear Wayne,

Thanks. Yes I have an ID field linking the main table to the popup.

Ken