I am new to Access. I have created a form from query that links to an Excel that I have imported (not a local file) and my goal is to create multi fields to search for records from the form. So how can I remove the popup as I want to able to type in parameters and search from the form, not enter one by one through the popup. The queries that I have I use Build to write so it should not have any mistakes. I am not sure how to fix the problem. Popup shows something like this “Forms!frmHD!StoreName”. I have used a split field.
I was expecting able to type in textboxes/comboboxes that I have created and press “search” and generate any records that match the criteria.
What do you mean by “split field” – did you mean “split form”? That should not make any difference to the code. The popup is because Access cannot find Forms!frmHD!StoreName. Is this form open? I don’t use dynamic parameters in query. I prefer VBA to build filter criteria and apply to form or report. Review this tutorial allenbrowne.com/ser-62.html.