Haven't tried to download or open your db, but if you set the recordsource for an object at run time, you usually have to requery it, otherwise it doesn't reflect the change. Did you try that?
Private Sub btn_Search_Click()
Code:
TempVars.Add "varBrideForenames", Me.txtBrideForenames.Value
DoCmd.Close acForm, "frm_BannsBrideForenameSearch"
DoCmd.OpenForm "frm_BannsResults", acNormal, "", "", , acNormal
Forms!frm_BannsResults.RecordSource = "qry_BannsBrideForenameSearch"
Me.Requery
End Sub
If it's possible that the first form is not open when this runs (maybe a user closes it manually) trying to close it will generate an error. In those cases, I include
Code:
If CurrentProject.Allforms("frm_BannsBrideForenameSearch").IsLoaded Then
DoCmd.Close acForm, "frm_BannsBrideForenameSearch"
End If
If memory serves, you seem bent on using the wrong window open argument (acNormal instead of acWindowNormal)