I have a help desk database with a customer search form that pulls up all tickets submitted by a customer. The subform (tickets) is currently linked to the customer form based on whose record you look up. I would like the subform to come up showing all tickets for the customer and have a list box that will filter the results based on the status of the ticket.
I have tried putting a [where] clause in the control source but that only limikts it to a choice in the box and will not show all records at startup. Any suggestions on how to allow it to show all on startup?
I originally had tabbed pages that pulled up a seperate query for each (All, Open and Closed) but am trying to find ways to speed up the processes.
I have tried putting a [where] clause in the control source but that only limikts it to a choice in the box and will not show all records at startup. Any suggestions on how to allow it to show all on startup?
I originally had tabbed pages that pulled up a seperate query for each (All, Open and Closed) but am trying to find ways to speed up the processes.
