I have a main form “Switchboard” with a cmd button that open another form, “Input”. Form “Input” data source is “tbl_Observation_List”…..so when I make an addition to from Input it adds “tbl_Observation_List”.
there is a qry called qry_TenRecent_Additions that pulls the recent 10 entries from the “tbl_Observation_List”…..so I’ve created a subform called “qry_TenRecent_Additions subform” and it is part of “Switchboard”.
The prob is that the when I open “Input” and make and entry (basically updating the main list for subform “qry_TenRecent_Additions subform” then close “Input”, putting focus on the “Switchboard” i am not seeing the new addtiont ot eh subform.
NOTE: If I close and reopen “Switchboard” then the newly added data is shown in the subform.
Here is my attempt to refresh Switchboard
Private Sub Form_Activate()
DoCmd.SetWarnings False
'DoCmd.RunSQL ("qry_TenRecent_Additions")
Me.[qry_TenRecent_Additions subform].Form.Refresh
DoCmd.SetWarnings True
Does it need to be on a different action?
Thanks
TukTuk
there is a qry called qry_TenRecent_Additions that pulls the recent 10 entries from the “tbl_Observation_List”…..so I’ve created a subform called “qry_TenRecent_Additions subform” and it is part of “Switchboard”.
The prob is that the when I open “Input” and make and entry (basically updating the main list for subform “qry_TenRecent_Additions subform” then close “Input”, putting focus on the “Switchboard” i am not seeing the new addtiont ot eh subform.
NOTE: If I close and reopen “Switchboard” then the newly added data is shown in the subform.
Here is my attempt to refresh Switchboard
Private Sub Form_Activate()
DoCmd.SetWarnings False
'DoCmd.RunSQL ("qry_TenRecent_Additions")
Me.[qry_TenRecent_Additions subform].Form.Refresh
DoCmd.SetWarnings True
Does it need to be on a different action?
Thanks
TukTuk