Hi
I'm adding a record to a table and then I want to be able to see that record in the Datasheet form but its not there. I have to select the datasheet and then click refresh for it to appear. I've tried refresh and requery but nothing seems to work...
Any help would be appreciated.
I'm adding a record to a table and then I want to be able to see that record in the Datasheet form but its not there. I have to select the datasheet and then click refresh for it to appear. I've tried refresh and requery but nothing seems to work...
Code:
Forms![frm_Tracker]![multifrm_Master_Staff_List]![dsfrm_Master_Staff_List].Form.SetFocus
Forms![frm_Tracker]![multifrm_Master_Staff_List]![dsfrm_Master_Staff_List].Form.Refresh
Forms![frm_Tracker]![multifrm_Master_Staff_List]![dsfrm_Master_Staff_List].Form.Requery
Any help would be appreciated.