refresh popup

  • Thread starter Thread starter Ken Ivins
  • Start date Start date
K

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
 
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.
 
Dear Wayne,

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

Ken
 
Back
Top