on the same form, I get an error when opening on the "on current" and "on Load"
#Private Sub Form_Current()
If Me.RecordsetClone.RecordCount = 0 Then
DoCmd.OpenQuery "Clear_Registration_File"
DoCmd.OpenQuery "Update_Registration_All"
Me.Requery
End If
End Sub
Private Sub Form_Load()
If Me.RecordsetClone.RecordCount = 0 Then
DoCmd.OpenQuery "Clear_Registration_File"
DoCmd.OpenQuery "Update_Registration_All"
Me.Requery
End If
End Sub#