Hi.
(Access 2002 - Windows XP Pro)
I have a select query called "Find Suppliers". One of its fields is "supplierName" which is derived from a linked "Suppliers" table.
I have a form called "Select Suppliers" which has a combobox which lists all the suppliers names and is derived from a small select query.
I have a second form called "Show Suppliers" which I want to use to show all the suppliers extracted from the "Find Suppliers" query based on the "Select Suppliers " form with the combobox.
I've tried various combinations of filtering in the query as well as the "Show Suppliers" form and getting in an awful muddle on who is passing what to whom.
My second form above shows all the suppliers irrespective on what I ask. The "Find Suppliers" query insists on asking for the search parameters.
Could someone help to point me in the right direction, please? Thanks
Roderick