Well I have worked to try and figure out how to easily get this data to update and the following code is the only way I can get it to work is there a better way to do this?
Code:
DoCmd.OpenTable "ss_cur_base", acViewNormal, acReadOnlyDoCmd.ApplyFilter , "mach_seq = 10477"
DoCmd.RunCommand acCmdRemoveFilterSort
DoCmd.ApplyFilter , "mach_seq = 10477"
DoCmd.RunCommand acCmdRemoveFilterSort
DoCmd.Close acTable, "ss_cur_base", acSaveNo
Me.Requery
Me.Refresh
I am using this code on a form timer as well as refresh buttons throughout the different forms and dashboards.
If there is another better way to do this let me know.
Thanks for you time
JR