I want to open a form, JobReports, from another form.
I have added a command button with the following code to filter records, but it does not seem to load efficiently.
I am putting the code in the correct place?
Private Sub OpenJobReports_Click()
Forms![JobReports].Filter = "[Status] = " & Chr(34) & "Completed" & Chr(34) & " OR [Status] = " & Chr(34) & "In progress" & Chr(34)
Forms![JobReports].FilterOn = True
DoCmd.GoToRecord , , acLast