Search results

Hi thanks for the advice but I managed to solve the problem and it works just fine - thank you for your help it has saved me alot of time :)

Ok I will have to try and figure out why it works for you and not for me...strange...many, many thanks for your help :) Pauline

Hi thanks for getting back to me - i checked out what you did and it sort of worked but now its stuck on listing products from just one supplier. Have done a printscreen view for you. As you will see, the supplier on the screen is Abraclean but the products in the combobox will only show...

Hi have tried again to compact and then compress the file - hopefully it will work this time - pauline

Hi thanks I will retry and let you know how I get on :-)

Hi thanks for your help - it half worked, it filtered the productID combo box but the Combo box will only list products supplied from the supplier that is firt selected - it wont change. Hope this makes sense !!! Pauline

Hi, hope someone can help. I have a Suppliers database which contains a form that will allow me to place orders with Suppliers. The Main form has a combo box that allows me to select the supplier. The combo box is called SupplierID with the following: Row source: SELECT...

Hi, thanks for replying - No the combo references only refer to two tables though there are other tables involved in the queries for the forms. Both Comboboxes use DLookup against the two tables Suppliers and Products. I am thinking that its the actual statement expression thats wrong -what...

Hi, hope you can help. I have a suppliers table and a products table. Two forms, Stock form with combobox to list Suppliers and a sub form with combobox that lists Products. I want to select a supplier from the Stock form and then the combobox in the subform to only list products directly...

Hi, I am based in the UK and have dabbled in Access for a number of years but have done little with actual programing so am hoping some kine person out there can help me with a query.:)