I am looking to create a search form that allows users to enter criteria into unbound txt boxes and choose values from a list and then search by them when hitting a search button. The results of the query will populate a subform and then the user can dbl click the record and view the contents of that record in another form.
I created two forms, one subform and the strSQL. How do I get the results of my query to populate the subform and then pass the selected record into a form for the user to view?
I tried this
Forms!frm_Result.RecordSource = strSQL
But I get an error saying that the form either does not exist or it is not open.