You would think every person making an access database would want or does use this at some point, but after hours of searching, I am at a loss.
I have a service ticket system with several tables, one being the customer table.
I know how to create a search form and how to get the results to a report.
Problem is I need the search form to list customers matching the search criteria in a list below the form, then the user should be able to select the record from the list to open that customer's record in the customer entry form. Simple right?
Well I am stumped on how to create a continuous form that would do this.
You don't have to give a complete solution, I am ok with what I should be searching for - trust me - continuous form search in google yields little on how to do this common task (I would think it would be common enough, but apparently not).
Thanks in advance.