Hello,
I'm new to Access, VBA, and databases in general, additionally sorry if this has been asked/answered I have searched and . I'm having issues with creating a report from a subform that has all the records on it. I have a combobox that filters the table by Subject (five categories) and would like a text box that further filters based on a user search. I have a report that works but only finds the selected record from the subform. Hope that make sense and any help is appreciated.
Table - Riparian_Assessment
Form - RA_Search
SubForm - RA_Subform
Report - Riparian Report
Code under the button: Open Report
Private Sub Open_Report_Click()
stCriteria = "[ID] = " & Me![ID]
DoCmd.OpenReport "Riparian Report", acViewPreview, , "ID=" & Me!RA_Subform.Form.ID
End Sub
Thanks
Bill