P Peter Apr 7, 2009 #1 Hi again all at this fantastic place....how do i translate the Shift + F9 (requery) a form...???
F fredg Apr 7, 2009 #2 Hi again all at this fantastic place....how do i translate the Shift + F9 (requery) a form...??? Click to expand... In code from an event on that form? Me.Requery
Hi again all at this fantastic place....how do i translate the Shift + F9 (requery) a form...??? Click to expand... In code from an event on that form? Me.Requery
P Peter Apr 8, 2009 #3 Thanks fredg...made my day! i used this from the refresh button code.. Private Sub Requery_Form_Click() On Error GoTo Err_Requery_Form_Click Me.Form.Requery Exit_Requery_Form_Click: Exit Sub Err_Requery_Form_Click: MsgBox Err.Description Resume Exit_Requery_Form_Click End Sub Once again, thanks a lot!
Thanks fredg...made my day! i used this from the refresh button code.. Private Sub Requery_Form_Click() On Error GoTo Err_Requery_Form_Click Me.Form.Requery Exit_Requery_Form_Click: Exit Sub Err_Requery_Form_Click: MsgBox Err.Description Resume Exit_Requery_Form_Click End Sub Once again, thanks a lot!